APPS.WMS_PICK_DROP_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 115: FROM mtl_txn_request_lines mtrl

111: ( p_mo_line_id IN NUMBER
112: ) IS
113: SELECT mtrh.move_order_type
114: , mtrl.line_status
115: FROM mtl_txn_request_lines mtrl
116: , mtl_txn_request_headers mtrh
117: WHERE mtrl.line_id = p_mo_line_id
118: AND mtrl.header_id = mtrh.header_id;
119:

Line 869: , mtl_txn_request_lines mtrl

865: to_char(mtrl.line_status)
866: )
867: )
868: FROM mtl_material_transactions_temp mmtt
869: , mtl_txn_request_lines mtrl
870: , mtl_txn_request_headers mtrh
871: WHERE mmtt.organization_id = p_org_id
872: --Modified for Bug 6717052
873: AND (mmtt.transfer_lpn_id = p_lpn_id OR mmtt.transfer_lpn_id IN (SELECT wlpn.lpn_id FROM wms_license_plate_numbers wlpn

Line 947: , mtl_txn_request_lines mtrl

943: )
944: )
945: )
946: FROM mtl_material_transactions_temp mmtt
947: , mtl_txn_request_lines mtrl
948: , wsh_delivery_details_ob_grp_v wdd
949: , wsh_delivery_assignments_v wda
950: WHERE mmtt.organization_id = p_org_id
951: --Modified for Bug 6717052

Line 979: , mtl_txn_request_lines mtrl

975: to_char(mtrl.reference_id)
976: )
977: )
978: FROM mtl_material_transactions_temp mmtt
979: , mtl_txn_request_lines mtrl
980: WHERE mmtt.organization_id = p_org_id
981: AND mmtt.transfer_lpn_id = p_lpn_id
982: AND mmtt.move_order_line_id = mtrl.line_id;
983:

Line 3361: , mtl_txn_request_lines mtrl

3357: ) parent_line_id
3358: FROM mtl_material_transactions_temp mmtt
3359: , mtl_secondary_inventories msi
3360: , mtl_item_locations mil
3361: , mtl_txn_request_lines mtrl
3362: , wsh_delivery_details_ob_grp_v wdd
3363: , wsh_delivery_assignments_v wda
3364: WHERE mmtt.organization_id = p_org_id
3365: AND mmtt.transfer_lpn_id = p_lpn_id

Line 3407: , mtl_txn_request_lines mtrl

3403: ) parent_line_id
3404: FROM mtl_material_transactions_temp mmtt
3405: , mtl_secondary_inventories msi
3406: , mtl_item_locations mil
3407: , mtl_txn_request_lines mtrl
3408: , mtl_txn_request_headers mtrh
3409: WHERE mmtt.organization_id = p_org_id
3410: AND mmtt.transfer_lpn_id = p_lpn_id
3411: AND mmtt.transaction_action_id = 2

Line 3451: , mtl_txn_request_lines mtrl

3447: ) parent_line_id
3448: FROM mtl_material_transactions_temp mmtt
3449: , mtl_secondary_inventories msi
3450: , mtl_item_locations mil
3451: , mtl_txn_request_lines mtrl
3452: , mtl_txn_request_headers mtrh
3453: WHERE mmtt.organization_id = p_org_id
3454: AND mmtt.transfer_lpn_id = p_lpn_id
3455: AND mmtt.transaction_action_id = 2

Line 3493: , mtl_txn_request_lines mtrl

3489: , NULL, 0
3490: , 1
3491: ) parent_line_id
3492: FROM mtl_material_transactions_temp mmtt
3493: , mtl_txn_request_lines mtrl
3494: WHERE mmtt.organization_id = p_org_id
3495: AND mmtt.transfer_lpn_id = p_lpn_id
3496: AND mmtt.transaction_action_id = 1
3497: AND mmtt.transaction_source_type_id = 5

Line 3528: , mtl_txn_request_lines mtrl

3524: , NULL, 0
3525: , 1
3526: ) parent_line_id
3527: FROM mtl_material_transactions_temp mmtt
3528: , mtl_txn_request_lines mtrl
3529: WHERE mmtt.organization_id = p_org_id
3530: AND mmtt.transfer_lpn_id = p_lpn_id
3531: AND mmtt.transaction_action_id IN (2,28)
3532: AND mmtt.move_order_line_id = mtrl.line_id

Line 3980: , mtl_txn_request_lines mtrl

3976: ( p_temp_id IN NUMBER
3977: ) IS
3978: SELECT wip_entity_type
3979: FROM mtl_material_transactions_temp mmtt
3980: , mtl_txn_request_lines mtrl
3981: , wip_entities we
3982: WHERE mmtt.transaction_temp_id = p_temp_id
3983: AND mmtt.transaction_source_type_id = 5
3984: AND mmtt.transaction_action_id = 1

Line 7415: , mtl_txn_request_lines mtrl

7411: , mmtt.transfer_to_location
7412: , mtrl.carton_grouping_id
7413: , wda.delivery_id
7414: FROM mtl_material_transactions_temp mmtt
7415: , mtl_txn_request_lines mtrl
7416: , wsh_delivery_details_ob_grp_v wdd
7417: , wsh_delivery_assignments_v wda
7418: WHERE mmtt.organization_id = p_org_id
7419: AND mmtt.transfer_lpn_id = p_lpn_id

Line 7435: , mtl_txn_request_lines mtrl

7431: SELECT mtrl.carton_grouping_id
7432: FROM wsh_delivery_details_ob_grp_v wdd
7433: , wsh_delivery_assignments_v wda
7434: , wsh_delivery_details_ob_grp_v wdd2
7435: , mtl_txn_request_lines mtrl
7436: WHERE wdd.lpn_id = p_lpn_id
7437: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7438: AND wdd.organization_id = p_org_id
7439: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id

Line 7449: , mtl_txn_request_lines mtrl

7445: ( p_temp_id IN NUMBER
7446: ) IS
7447: SELECT mtrl.carton_grouping_id
7448: FROM mtl_material_transactions_temp mmtt
7449: , mtl_txn_request_lines mtrl
7450: WHERE mmtt.transaction_temp_id = p_temp_id
7451: AND mmtt.move_order_line_id = mtrl.line_id;
7452:
7453: BEGIN