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_QUANTITY_TREE_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 5027: mtl_transaction_lots_temp mtlt,

5023: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5024: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5025: FROM
5026: mtl_material_transactions_temp mmtt,
5027: mtl_transaction_lots_temp mtlt,
5028: mtl_parameters mp -- Bug 9938149
5029: WHERE
5030: mmtt.posting_flag = 'Y'
5031: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5073: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt

5069: mmtt.transaction_action_id IN (1,2,27,28)) --FlexiLotAlloc
5070: AND mmtt.transaction_action_id in (1,2,27,28) --FlexiLotAlloc and BUG 10070839
5071: AND mmtt.transaction_source_type_id in (2,4,5,8) --FlexiLotAlloc
5072: AND nvl(mmtt.wip_entity_type,-1) NOT IN (9,10)
5073: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt
5074: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)
5075: UNION ALL
5076: -- receiving side of transfers, lot in MMTT
5077: SELECT

Line 5132: mtl_transaction_lots_temp mtlt

5128: , to_char(NULL) transfer_subinventory_code
5129: , to_number(NULL) transfer_locator_id
5130: FROM
5131: mtl_material_transactions_temp mmtt,
5132: mtl_transaction_lots_temp mtlt
5133: WHERE
5134: mmtt.posting_flag = 'Y'
5135: AND mmtt.lot_number IS NULL
5136: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5456: mtl_transaction_lots_temp mtlt,

5452: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5453: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5454: FROM
5455: mtl_material_transactions_temp mmtt,
5456: mtl_transaction_lots_temp mtlt,
5457: mtl_parameters mp -- bug 9938149
5458: WHERE
5459: mmtt.posting_flag = 'Y'
5460: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5536: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt

5532: mmtt.transaction_action_id IN (1,2,27,28)) --FlexiLotAlloc
5533: AND mmtt.transaction_action_id in (1,2,27,28) --FlexiLotAlloc and BUG 10070839
5534: AND mmtt.transaction_source_type_id in (2,4,5,8) --FlexiLotAlloc
5535: AND nvl(mmtt.wip_entity_type,-1) NOT IN (9,10) --FlexiLotAlloc
5536: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt
5537: WHERE mmtt.transaction_temp_id = mtlt.transaction_temp_id)
5538: UNION ALL
5539: -- receiving side of transfers lot in MMTT
5540: SELECT

Line 5652: ,mtl_transaction_lots_temp mtlt

5648: , to_char(NULL) transfer_subinventory_code
5649: , to_number(NULL) transfer_locator_id
5650: FROM
5651: mtl_material_transactions_temp mmtt
5652: ,mtl_transaction_lots_temp mtlt
5653: WHERE
5654: mmtt.posting_flag = 'Y'
5655: AND mmtt.lot_number IS NULL
5656: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5897: mtl_transaction_lots_temp mtlt,

5893: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5894: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5895: FROM
5896: mtl_material_transactions_temp mmtt,
5897: mtl_transaction_lots_temp mtlt,
5898: mtl_parameters mp -- Bug 9938149
5899: WHERE
5900: mmtt.posting_flag = 'Y'
5901: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5972: mtl_transaction_lots_temp mtlt

5968: , to_char(NULL) transfer_subinventory_code
5969: , to_number(NULL) transfer_locator_id
5970: FROM
5971: mtl_material_transactions_temp mmtt,
5972: mtl_transaction_lots_temp mtlt
5973: WHERE
5974: mmtt.posting_flag = 'Y'
5975: AND mmtt.lot_number IS NULL
5976: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6235: mtl_transaction_lots_temp mtlt

6231: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6232: ) status_id -- Onhand Material Status Support
6233: FROM
6234: mtl_material_transactions_temp mmtt,
6235: mtl_transaction_lots_temp mtlt
6236: , mtl_parameters mp -- Bug 9938149
6237: WHERE
6238: mmtt.posting_flag = 'Y'
6239: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6287: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt

6283: mmtt.transaction_action_id IN (1,2,27,28))--FlexiLotAlloc
6284: AND mmtt.transaction_action_id in (1,2,27,28) --FlexiLotAlloc and BUG 10070839
6285: AND mmtt.transaction_source_type_id in (2,4,5,8) --FlexiLotAlloc
6286: AND nvl(mmtt.wip_entity_type,-1) NOT IN (9,10) --FlexiLotAlloc
6287: AND NOT EXISTS (SELECT 1 FROM mtl_transaction_lots_temp mtlt
6288: WHERE transaction_temp_id = mmtt.transaction_temp_id)
6289: UNION ALL
6290: -- receiving side of transfers, lot in MMTT
6291: -- Bug 7658493, If wms task is in loaded status, consider allocation like pending transaction.

Line 6384: mtl_transaction_lots_temp mtlt

6380: )
6381: ) status_id -- Onhand Material Status Support
6382: FROM
6383: mtl_material_transactions_temp mmtt,
6384: mtl_transaction_lots_temp mtlt
6385: WHERE
6386: mmtt.posting_flag = 'Y'
6387: AND mmtt.lot_number IS NULL
6388: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6667: mtl_transaction_lots_temp mtlt

6663: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6664: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6665: FROM
6666: mtl_material_transactions_temp mmtt,
6667: mtl_transaction_lots_temp mtlt
6668: , mtl_parameters mp -- Bug 9938149
6669: WHERE
6670: mmtt.posting_flag = 'Y'
6671: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6741: mtl_transaction_lots_temp mtlt

6737: , to_char(NULL) transfer_subinventory_code
6738: , to_number(NULL) transfer_locator_id
6739: FROM
6740: mtl_material_transactions_temp mmtt,
6741: mtl_transaction_lots_temp mtlt
6742: WHERE
6743: mmtt.posting_flag = 'Y'
6744: AND mmtt.lot_number IS NULL
6745: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7002: mtl_transaction_lots_temp mtlt

6998: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6999: ) status_id -- Onhand Material Status Support
7000: FROM
7001: mtl_material_transactions_temp mmtt,
7002: mtl_transaction_lots_temp mtlt
7003: , mtl_parameters mp -- Bug 9938149
7004: WHERE
7005: mmtt.posting_flag = 'Y'
7006: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7112: mtl_transaction_lots_temp mtlt

7108: )
7109: ) status_id -- Onhand Material Status Support
7110: FROM
7111: mtl_material_transactions_temp mmtt,
7112: mtl_transaction_lots_temp mtlt
7113: WHERE
7114: mmtt.posting_flag = 'Y'
7115: AND mmtt.lot_number IS NULL
7116: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7780: mtl_transaction_lots_temp mtlt

7776: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7777: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7778: FROM
7779: mtl_material_transactions_temp mmtt,
7780: mtl_transaction_lots_temp mtlt
7781: , mtl_parameters mp -- Bug 9938149
7782: WHERE
7783: mmtt.posting_flag = 'Y'
7784: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7910: ,mtl_transaction_lots_temp mtlt

7906: , to_char(NULL) transfer_subinventory_code
7907: , to_number(NULL) transfer_locator_id
7908: FROM
7909: mtl_material_transactions_temp mmtt
7910: ,mtl_transaction_lots_temp mtlt
7911: WHERE
7912: mmtt.posting_flag = 'Y'
7913: AND mmtt.lot_number IS NULL
7914: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 8236: mtl_transaction_lots_temp mtlt

8232: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
8233: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
8234: FROM
8235: mtl_material_transactions_temp mmtt,
8236: mtl_transaction_lots_temp mtlt
8237: , mtl_parameters mp -- Bug 9938149
8238: WHERE
8239: mmtt.posting_flag = 'Y'
8240: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 8366: ,mtl_transaction_lots_temp mtlt

8362: , to_char(NULL) transfer_subinventory_code
8363: , to_number(NULL) transfer_locator_id
8364: FROM
8365: mtl_material_transactions_temp mmtt
8366: ,mtl_transaction_lots_temp mtlt
8367: WHERE
8368: mmtt.posting_flag = 'Y'
8369: AND mmtt.lot_number IS NULL
8370: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id