MSC_AP_MOVEMENT_REQUESTS_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
MO_LINE_ID ORDER_NUMBER MO_LINE_NUMBER DISPOSITION_ID ORDER_TYPE FG_ORDER_TYPE SOURCE_ORGANIZATION_ID FROM_ORGANIZATION_CODE SOURCE_SUBINVENTORY_CODE ORGANIZATION_ID ORGANIZATION_CODE SUBINVENTORY_CODE INVENTORY_ITEM_ID ITEM_NAME NEED_BY_DATE NEW_SCHEDULE_DATE NEW_ORDER_PLACEMENT_DATE NEW_ORDER_QUANTITY QTY_COMPLETED LINES_ROW_ID HEADER_ROW_ID INV_LINE_STATUS

Query

SQL_Statement

SELECT /*+ leading(mtrl) */ mtrl.line_id mo_line_id, mtrh.request_number order_number, mtrl.line_number mo_line_number, mtrh.header_id disposition_id, 95 order_type, 9500 fg_order_type , mtrl.organization_id source_organization_id, items.organization_code from_organization_code, mtrl.from_subinventory_code source_subinventory_code, mtrl.organization_id organization_id, items.organization_code organization_code, mtrl.to_subinventory_code subinventory_code, mtrl.inventory_item_id inventory_item_id, items.item_number item_name, mtrl.date_required need_by_date, mtrl.date_required new_schedule_date, mtrl.date_required new_order_placement_date, mtrl.primary_quantity new_order_quantity, mtrl.quantity_delivered qty_completed, mtrl.rowid lines_row_id, mtrh.rowid header_row_id, mtrl.line_status inv_line_status FROM inv_txn_request_lines mtrl , inv_txn_request_headers mtrh , egp_system_items_vl items , msc_parameters mp WHERE mtrl.transaction_type_id = 64 AND mtrh.move_order_type = 2 AND mtrl.organization_id = items.organization_id AND mtrl.inventory_item_id = items.inventory_item_id AND items.mrp_planning_code = 10 AND items.organization_code = mp.organization_code AND mp.subinv_planning_enabled = 1 AND mtrl.line_status IN (3,7) AND mtrh.header_id = mtrl.header_id AND EXISTS ( SELECT 1 FROM inv_secondary_inventories msi WHERE msi.organization_id = mtrl.organization_id AND msi.secondary_inventory_name = mtrl.to_subinventory_code AND msi.availability_type = 1 )