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.INV_LABEL_PVT1 dependencies on WIP_ENTITIES

Line 724: , wip_entities we -- Added for Bug#4516067

720: , per_people_f ppf
721: , rcv_routing_headers rrh
722: -- Bug 4516067, to improve performance, query the base table directly
723: --, wip_osp_jobs_val_v wojv
724: , wip_entities we -- Added for Bug#4516067
725: , wip_discrete_jobs wdj -- Added for Bug#4516067
726: , wms_license_plate_numbers wlpn -- Bug 3836623
727: , (SELECT cost_group_id, rcv_transaction_id
728: FROM mtl_material_transactions mmt1

Line 922: , wip_entities we

918: , per_people_f ppf
919: , rcv_routing_headers rrh
920: -- Bug 4516067, to improve performance, query the base table directly
921: --, wip_osp_jobs_val_v wojv
922: , wip_entities we
923: , wip_discrete_jobs wdj
924: , wms_license_plate_numbers wlpn -- Bug 3836623
925: , (SELECT cost_group_id, rcv_transaction_id
926: FROM mtl_material_transactions mmt1

Line 1105: , wip_entities we

1101: , per_people_f ppf
1102: , rcv_routing_headers rrh
1103: -- Bug 4516067, to improve performance, query the base table directly
1104: --, wip_osp_jobs_val_v wojv
1105: , wip_entities we
1106: , wip_discrete_jobs wdj
1107: , wms_license_plate_numbers wlpn -- Bug 3836623
1108: WHERE mtln.product_transaction_id(+) = rt.transaction_id
1109: AND mtln.product_code(+) = 'RCV'

Line 1318: ,wip_entities we -- Fix For Bug: 4907062

1314: , mtlt.supplier_lot_number -- invconv end
1315: , mtlt.lot_expiration_date --bug13936282
1316: FROM mtl_material_transactions_temp mmtt
1317: ,mtl_transaction_lots_temp mtlt
1318: ,wip_entities we -- Fix For Bug: 4907062
1319: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1320: AND mmtt.transaction_temp_id = p_transaction_id
1321: AND we.wip_entity_id(+) = mmtt.transaction_source_id; -- Fix For Bug: 4907062
1322: /* Outer join has been added to fetch the data while performing the Misc. Alias/Receipt

Line 1629: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, wip_entities we --11682748 get wip entity info

1625: , mmtt.locator_id
1626: , we.wip_entity_id --11682748 get wip entity info
1627: , we.wip_entity_name --11682748 get wip entity info
1628: , we.description --11682748 get wip entity info
1629: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, wip_entities we --11682748 get wip entity info
1630: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
1631: AND we.wip_entity_id(+)=mmtt.transaction_source_id --11682748 get wip entity info
1632: AND mmtt.transaction_temp_id = p_transaction_id; --11682748 get wip entity info
1633:

Line 2019: wip_entities wipe

2015: wipe.wip_entity_name,
2016: mmtt.trx_source_line_id
2017: FROM mtl_material_transactions_temp mmtt,
2018: mtl_transaction_lots_temp mtlt ,
2019: wip_entities wipe
2020: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
2021: AND mmtt.transaction_temp_id = p_transaction_id
2022: AND mmtt.transaction_source_id = wipe.wip_entity_id
2023: AND mmtt.content_lpn_id IS NULL

Line 2047: wip_entities wipe

2043: wipe.wip_entity_name ,
2044: mmtt.trx_source_line_id
2045: FROM wms_lpn_contents wlc ,
2046: mtl_material_transactions_temp mmtt,
2047: wip_entities wipe
2048: WHERE mmtt.transaction_temp_id = p_transaction_id
2049: AND mmtt.transaction_source_id = wipe.wip_entity_id
2050: AND mmtt.content_lpn_id IS NOT NULL
2051: AND mmtt.content_lpn_id = wlc.parent_lpn_id;