DBA Data[Home] [Help]

APPS.WMS_BULK_PICK dependencies on MTL_TXN_REQUEST_LINES

Line 1017: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1013: SELECT mmtt.transaction_temp_id
1014: , mmtt.transaction_uom
1015: , mmtt.transaction_quantity
1016: , mmtt.primary_quantity
1017: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1018: wsh_delivery_details wdd,wsh_delivery_assignments_v wda
1019: WHERE mmtt.parent_line_id = p_temp_id
1020: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line
1021: AND mmtt.organization_id = p_org_id

Line 1033: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,

1029: SELECT mmtt.transaction_temp_id
1030: , mmtt.transaction_uom
1031: , mmtt.transaction_quantity
1032: , mmtt.primary_quantity
1033: FROM mtl_material_transactions_temp mmtt,mtl_txn_request_lines mol,
1034: wsh_delivery_details wdd,wsh_delivery_assignments_v wda,
1035: oe_order_lines_all ol,mtl_txn_request_headers moh
1036: WHERE mmtt.parent_line_id = p_temp_id
1037: AND mmtt.parent_line_id <> mmtt.transaction_temp_id -- exclude the parent line