[Home] [Help]
1003: wda.delivery_id,mtrl.carton_grouping_id
1004: INTO l_delivery_id,l_carton_grouping_id
1005: FROM
1006: mtl_material_transactions_temp mmtt
1007: , mtl_txn_request_lines mtrl
1008: , wsh_delivery_details wdd
1009: , wsh_delivery_assignments_v wda
1010: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1011: AND mmtt.move_order_line_id = mtrl.line_id
1017: mtrl.carton_grouping_id
1018: INTO l_carton_grouping_id
1019: FROM
1020: mtl_material_transactions_temp mmtt
1021: , mtl_txn_request_lines mtrl
1022: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1023: AND mmtt.move_order_line_id = mtrl.line_id;
1024: END IF;
1025: IF l_delivery_id is not null THEN
1044: BEGIN
1045: SELECT wda.delivery_id,mtrl.carton_grouping_id
1046: INTO l_delivery_id,l_carton_grouping_id
1047: FROM mtl_material_transactions_temp mmtt
1048: , mtl_txn_request_lines mtrl
1049: , wsh_delivery_details wdd
1050: , wsh_delivery_assignments_v wda
1051: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1052: AND mmtt.move_order_line_id = mtrl.line_id
1060: END IF;
1061: SELECT mtrl.carton_grouping_id
1062: INTO l_carton_grouping_id
1063: FROM mtl_material_transactions_temp mmtt
1064: , mtl_txn_request_lines mtrl
1065: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1066: AND mmtt.move_order_line_id = mtrl.line_id;
1067: END;
1068:
1128: --Resolve move_order_type from l_transaction_temp_id
1129: SELECT mtrh.move_order_type
1130: INTO l_move_order_type
1131: FROM mtl_txn_request_headers mtrh,
1132: mtl_txn_request_lines mtrl,
1133: mtl_material_transactions_temp mmtt
1134: WHERE mmtt.move_order_line_id = mtrl.line_id
1135: AND mtrl.header_id = mtrh.header_id
1136: AND mmtt.transaction_temp_id = l_transaction_temp_id;
1354: FROM wms_dispatched_tasks wdt
1355: , mtl_material_transactions_temp mmtt
1356: , mtl_system_items_vl msik /* Bug 5581528 */
1357: , mtl_parameters mp
1358: , mtl_txn_request_lines mtrl
1359: , mtl_secondary_inventories msi
1360: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1361: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1362: AND mp.organization_id = wdt.organization_id
1476: FROM wms_dispatched_tasks wdt
1477: , mtl_material_transactions_temp mmtt
1478: , mtl_system_items_vl msik /* Bug 5581528 */
1479: , mtl_parameters mp
1480: , mtl_txn_request_lines mtrl
1481: , mtl_secondary_inventories msi
1482: WHERE mmtt.transaction_temp_id = l_transaction_temp_id
1483: AND wdt.transaction_temp_id = mmtt.transaction_temp_id
1484: AND mp.organization_id = wdt.organization_id
1620: SELECT DECODE (mtrh.move_order_type
1621: , inv_globals.g_move_order_mfg_pick, 'MFG'
1622: , 'OTHERS')
1623: FROM mtl_material_transactions_temp mmtt
1624: , mtl_txn_request_lines mtrl
1625: , mtl_txn_request_headers mtrh
1626: WHERE mmtt.organization_id = p_org_id
1627: AND mmtt.transfer_lpn_id = p_lpn_id
1628: AND mtrl.line_id = mmtt.move_order_line_id
1636: , mtrl.txn_source_id
1637: , mtrl.txn_source_line_id
1638: , mtrl.reference_id
1639: FROM mtl_material_transactions_temp mmtt
1640: , mtl_txn_request_lines mtrl
1641: WHERE mmtt.organization_id = p_org_id
1642: AND mmtt.transfer_lpn_id = p_lpn_id
1643: AND mtrl.line_id = mmtt.move_order_line_id;
1644:
1795: , mtrl.reference_id repetitive_schedule_id
1796: , mtrl.txn_source_line_id operation_seq_num
1797: , to_number(NULL) transfer_to_location --Bug#2756609
1798: FROM mtl_material_transactions_temp mmtt
1799: , mtl_txn_request_lines mtrl
1800: , wms_dispatched_tasks wdt
1801: , mtl_system_items_vl msik /* Bug 5581528 */
1802: WHERE mmtt.organization_id = p_organization_id
1803: AND mmtt.transfer_lpn_id = p_transfer_lpn_id