eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PICK_DROP_PVT dependencies on MTL_TXN_REQUEST_LINES

Line 125: FROM mtl_txn_request_lines mtrl

121: ( p_mo_line_id IN NUMBER
122: ) IS
123: SELECT mtrh.move_order_type
124: , mtrl.line_status
125: FROM mtl_txn_request_lines mtrl
126: , mtl_txn_request_headers mtrh
127: WHERE mtrl.line_id = p_mo_line_id
128: AND mtrl.header_id = mtrh.header_id;
129:

Line 886: , mtl_txn_request_lines mtrl

882: to_char(mtrl.line_status)
883: )
884: )
885: FROM mtl_material_transactions_temp mmtt
886: , mtl_txn_request_lines mtrl
887: , mtl_txn_request_headers mtrh
888: WHERE mmtt.organization_id = p_org_id
889: --Modified for Bug 6717052
890: 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 964: , mtl_txn_request_lines mtrl

960: )
961: )
962: )
963: FROM mtl_material_transactions_temp mmtt
964: , mtl_txn_request_lines mtrl
965: , wsh_delivery_details_ob_grp_v wdd
966: , wsh_delivery_assignments_v wda
967: WHERE mmtt.organization_id = p_org_id
968: --Modified for Bug 6717052

Line 991: , mtl_txn_request_lines mtrl

987: , p_lpn_id IN NUMBER
988: ) IS
989: SELECT Count(DISTINCT wda.delivery_id)
990: FROM mtl_material_transactions_temp mmtt
991: , mtl_txn_request_lines mtrl
992: , wsh_delivery_details_ob_grp_v wdd
993: , wsh_delivery_assignments_v wda
994: WHERE mmtt.organization_id = p_org_id
995: AND mmtt.transfer_lpn_id = p_lpn_id

Line 1017: , mtl_txn_request_lines mtrl

1013: , p_lpn_id IN NUMBER
1014: ) IS
1015: SELECT DISTINCT delivery_detail_id
1016: FROM mtl_material_transactions_temp mmtt
1017: , mtl_txn_request_lines mtrl
1018: , wsh_delivery_details wdd
1019: WHERE mmtt.organization_id = p_org_id
1020: AND mmtt.transfer_lpn_id = p_lpn_id
1021: AND ( (mmtt.parent_line_id IS NOT NULL

Line 1046: , mtl_txn_request_lines mtrl

1042: to_char(mtrl.reference_id)
1043: )
1044: )
1045: FROM mtl_material_transactions_temp mmtt
1046: , mtl_txn_request_lines mtrl
1047: WHERE mmtt.organization_id = p_org_id
1048: AND mmtt.transfer_lpn_id = p_lpn_id
1049: AND mmtt.move_order_line_id = mtrl.line_id;
1050:

Line 3548: , mtl_txn_request_lines mtrl

3544: ) parent_line_id
3545: FROM mtl_material_transactions_temp mmtt
3546: , mtl_secondary_inventories msi
3547: , mtl_item_locations mil
3548: , mtl_txn_request_lines mtrl
3549: , wsh_delivery_details_ob_grp_v wdd
3550: , wsh_delivery_assignments_v wda
3551: WHERE mmtt.organization_id = p_org_id
3552: AND mmtt.transfer_lpn_id = p_lpn_id

Line 3596: , mtl_txn_request_lines mtrl

3592: ) parent_line_id
3593: FROM mtl_material_transactions_temp mmtt
3594: , mtl_secondary_inventories msi
3595: , mtl_item_locations mil
3596: , mtl_txn_request_lines mtrl
3597: , mtl_txn_request_headers mtrh
3598: , wms_dispatched_tasks wdt -- Added for bug 12853197
3599: WHERE mmtt.organization_id = p_org_id
3600: AND mmtt.transfer_lpn_id = p_lpn_id

Line 3644: , mtl_txn_request_lines mtrl

3640: ) parent_line_id
3641: FROM mtl_material_transactions_temp mmtt
3642: , mtl_secondary_inventories msi
3643: , mtl_item_locations mil
3644: , mtl_txn_request_lines mtrl
3645: , mtl_txn_request_headers mtrh
3646: WHERE mmtt.organization_id = p_org_id
3647: AND mmtt.transfer_lpn_id = p_lpn_id
3648: AND mmtt.transaction_action_id = 2

Line 3688: , mtl_txn_request_lines mtrl

3684: , NULL, 0
3685: , 1
3686: ) parent_line_id
3687: FROM mtl_material_transactions_temp mmtt
3688: , mtl_txn_request_lines mtrl
3689: WHERE mmtt.organization_id = p_org_id
3690: AND mmtt.transfer_lpn_id = p_lpn_id
3691: AND mmtt.transaction_action_id = 1
3692: AND mmtt.transaction_source_type_id = 5

Line 3725: , mtl_txn_request_lines mtrl

3721: , NULL, 0
3722: , 1
3723: ) parent_line_id
3724: FROM mtl_material_transactions_temp mmtt
3725: , mtl_txn_request_lines mtrl
3726: WHERE mmtt.organization_id = p_org_id
3727: AND mmtt.transfer_lpn_id = p_lpn_id
3728: AND mmtt.transaction_action_id IN (2,28)
3729: AND mmtt.move_order_line_id = mtrl.line_id

Line 4258: , mtl_txn_request_lines mtrl

4254: ( p_temp_id IN NUMBER
4255: ) IS
4256: SELECT wip_entity_type
4257: FROM mtl_material_transactions_temp mmtt
4258: , mtl_txn_request_lines mtrl
4259: , wip_entities we
4260: WHERE mmtt.transaction_temp_id = p_temp_id
4261: AND mmtt.transaction_source_type_id = 5
4262: AND mmtt.transaction_action_id = 1

Line 7693: , mtl_txn_request_lines mtrl

7689: , mmtt.transfer_to_location
7690: , mtrl.carton_grouping_id
7691: , wda.delivery_id
7692: FROM mtl_material_transactions_temp mmtt
7693: , mtl_txn_request_lines mtrl
7694: , wsh_delivery_details_ob_grp_v wdd
7695: , wsh_delivery_assignments_v wda
7696: WHERE mmtt.organization_id = p_org_id
7697: AND mmtt.transfer_lpn_id = p_lpn_id

Line 7713: , mtl_txn_request_lines mtrl

7709: SELECT mtrl.carton_grouping_id
7710: FROM wsh_delivery_details_ob_grp_v wdd
7711: , wsh_delivery_assignments_v wda
7712: , wsh_delivery_details_ob_grp_v wdd2
7713: , mtl_txn_request_lines mtrl
7714: WHERE wdd.lpn_id = p_lpn_id
7715: AND wdd.released_status = 'X' -- For LPN reuse ER : 6845650
7716: AND wdd.organization_id = p_org_id
7717: AND wdd.delivery_detail_id = wda.parent_delivery_detail_id

Line 7727: , mtl_txn_request_lines mtrl

7723: ( p_temp_id IN NUMBER
7724: ) IS
7725: SELECT mtrl.carton_grouping_id
7726: FROM mtl_material_transactions_temp mmtt
7727: , mtl_txn_request_lines mtrl
7728: WHERE mmtt.transaction_temp_id = p_temp_id
7729: AND mmtt.move_order_line_id = mtrl.line_id;
7730:
7731: BEGIN