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_MATERIAL_TRANSACTIONS_TEMP

Line 646: mtl_material_transactions_temp mmtt

642: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
643: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
644: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
645: FROM
646: mtl_material_transactions_temp mmtt
647: WHERE
648: mmtt.posting_flag = ''Y''
649: AND mmtt.lot_number IS NOT NULL
650: AND mmtt.subinventory_code IS NOT NULL

Line 704: mtl_material_transactions_temp mmtt

700: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
701: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
702: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
703: FROM
704: mtl_material_transactions_temp mmtt
705: , mtl_transaction_lots_temp mtlt
706: WHERE
707: mmtt.posting_flag = ''Y''
708: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 741: mtl_material_transactions_temp mmtt

737: , to_char(NULL) transfer_subinventory_code
738: , to_number(NULL) transfer_locator_id
739:
740: FROM
741: mtl_material_transactions_temp mmtt
742: , mtl_transaction_lots_temp mtlt
743: WHERE
744: mmtt.posting_flag = ''Y''
745: AND mmtt.transaction_action_id IN (2,28,3,5)

Line 773: mtl_material_transactions_temp mmtt

769: , to_number(NULL) transaction_action_id
770: , to_char(NULL) transfer_subinventory_code
771: , to_number(NULL) transfer_locator_id
772: FROM
773: mtl_material_transactions_temp mmtt
774: WHERE
775: mmtt.posting_flag = ''Y''
776: AND mmtt.transaction_action_id IN (2,28,3,5)
777: AND Nvl(mmtt.transaction_status,0) <> 2 -- pending txns only

Line 828: mtl_material_transactions_temp mmtt

824: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
825: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
826: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
827: FROM
828: mtl_material_transactions_temp mmtt
829: WHERE
830: mmtt.posting_flag = ''Y''
831: AND mmtt.subinventory_code IS NOT NULL
832: AND (Nvl(mmtt.transaction_status,0) <> 2 OR -- pending txns

Line 861: mtl_material_transactions_temp mmtt

857: , to_number(NULL) transaction_action_id
858: , to_char(NULL) transfer_subinventory_code
859: , to_number(NULL) transfer_locator_id
860: FROM
861: mtl_material_transactions_temp mmtt
862: WHERE
863: mmtt.posting_flag = ''Y''
864: AND Nvl(mmtt.transaction_status,0) <> 2 -- pending txns only
865: AND mmtt.transaction_action_id IN (2,28,3,5) ';

Line 5265: mtl_material_transactions_temp mmtt

5261: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
5262: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5263: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5264: FROM
5265: mtl_material_transactions_temp mmtt
5266: WHERE
5267: mmtt.posting_flag = 'Y'
5268: AND mmtt.subinventory_code IS NOT NULL
5269: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 5296: mtl_material_transactions_temp mmtt

5292: , to_number(NULL) transaction_action_id
5293: , to_char(NULL) transfer_subinventory_code
5294: , to_number(NULL) transfer_locator_id
5295: FROM
5296: mtl_material_transactions_temp mmtt
5297: WHERE
5298: mmtt.posting_flag = 'Y'
5299: AND Decode( Nvl(mmtt.transaction_status,0),
5300: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 5475: mtl_material_transactions_temp mmtt

5471: ,NVL(mmtt.allocated_lpn_id,
5472: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
5473: ) status_id -- Onhand Material Status Support
5474: FROM
5475: mtl_material_transactions_temp mmtt
5476: WHERE
5477: mmtt.posting_flag = 'Y'
5478: AND mmtt.subinventory_code IS NOT NULL
5479: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 5527: mtl_material_transactions_temp mmtt

5523: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
5524: )
5525: ) status_id -- Onhand Material Status Support
5526: FROM
5527: mtl_material_transactions_temp mmtt
5528: WHERE
5529: mmtt.posting_flag = 'Y'
5530: AND Decode( Nvl(mmtt.transaction_status,0),
5531: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 5744: mtl_material_transactions_temp mmtt

5740: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
5741: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5742: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5743: FROM
5744: mtl_material_transactions_temp mmtt
5745: WHERE
5746: mmtt.posting_flag = 'Y'
5747: AND mmtt.lot_number IS NOT NULL
5748: AND mmtt.subinventory_code IS NOT NULL

Line 5787: mtl_material_transactions_temp mmtt,

5783: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
5784: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5785: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5786: FROM
5787: mtl_material_transactions_temp mmtt,
5788: mtl_transaction_lots_temp mtlt
5789: WHERE
5790: mmtt.posting_flag = 'Y'
5791: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 5822: mtl_material_transactions_temp mmtt

5818: , to_number(NULL) transaction_action_id
5819: , to_char(NULL) transfer_subinventory_code
5820: , to_number(NULL) transfer_locator_id
5821: FROM
5822: mtl_material_transactions_temp mmtt
5823: WHERE
5824: mmtt.posting_flag = 'Y'
5825: AND mmtt.lot_number IS NOT NULL
5826: AND Decode( Nvl(mmtt.transaction_status,0),

Line 5851: mtl_material_transactions_temp mmtt,

5847: , to_number(NULL) transaction_action_id
5848: , to_char(NULL) transfer_subinventory_code
5849: , to_number(NULL) transfer_locator_id
5850: FROM
5851: mtl_material_transactions_temp mmtt,
5852: mtl_transaction_lots_temp mtlt
5853: WHERE
5854: mmtt.posting_flag = 'Y'
5855: AND mmtt.lot_number IS NULL

Line 6033: mtl_material_transactions_temp mmtt

6029: ,NVL(mmtt.allocated_lpn_id,
6030: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6031: ) status_id -- Onhand Material Status Support
6032: FROM
6033: mtl_material_transactions_temp mmtt
6034: WHERE
6035: mmtt.posting_flag = 'Y'
6036: -- invConv bug 4074394 removed the fix in v115.141, because it only works
6037: -- when the ingredient item has no inventory.

Line 6086: mtl_material_transactions_temp mmtt,

6082: ,NVL(mmtt.allocated_lpn_id,
6083: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6084: ) status_id -- Onhand Material Status Support
6085: FROM
6086: mtl_material_transactions_temp mmtt,
6087: mtl_transaction_lots_temp mtlt
6088: WHERE
6089: mmtt.posting_flag = 'Y'
6090: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6139: mtl_material_transactions_temp mmtt

6135: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6136: )
6137: ) status_id -- Onhand Material Status Support
6138: FROM
6139: mtl_material_transactions_temp mmtt
6140: WHERE
6141: mmtt.posting_flag = 'Y'
6142: AND mmtt.lot_number IS NOT NULL
6143: AND Decode( Nvl(mmtt.transaction_status,0),

Line 6186: mtl_material_transactions_temp mmtt,

6182: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6183: )
6184: ) status_id -- Onhand Material Status Support
6185: FROM
6186: mtl_material_transactions_temp mmtt,
6187: mtl_transaction_lots_temp mtlt
6188: WHERE
6189: mmtt.posting_flag = 'Y'
6190: AND mmtt.lot_number IS NULL

Line 6400: mtl_material_transactions_temp mmtt

6396: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6397: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6398: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6399: FROM
6400: mtl_material_transactions_temp mmtt
6401: WHERE
6402: mmtt.posting_flag = 'Y'
6403: AND mmtt.lot_number IS NOT NULL
6404: AND mmtt.subinventory_code IS NOT NULL

Line 6443: mtl_material_transactions_temp mmtt,

6439: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
6440: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6441: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6442: FROM
6443: mtl_material_transactions_temp mmtt,
6444: mtl_transaction_lots_temp mtlt
6445: WHERE
6446: mmtt.posting_flag = 'Y'
6447: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6478: mtl_material_transactions_temp mmtt

6474: , to_number(NULL) transaction_action_id
6475: , to_char(NULL) transfer_subinventory_code
6476: , to_number(NULL) transfer_locator_id
6477: FROM
6478: mtl_material_transactions_temp mmtt
6479: WHERE
6480: mmtt.posting_flag = 'Y'
6481: AND mmtt.lot_number IS NOT NULL
6482: AND Decode( Nvl(mmtt.transaction_status,0),

Line 6507: mtl_material_transactions_temp mmtt,

6503: , to_number(NULL) transaction_action_id
6504: , to_char(NULL) transfer_subinventory_code
6505: , to_number(NULL) transfer_locator_id
6506: FROM
6507: mtl_material_transactions_temp mmtt,
6508: mtl_transaction_lots_temp mtlt
6509: WHERE
6510: mmtt.posting_flag = 'Y'
6511: AND mmtt.lot_number IS NULL

Line 6690: mtl_material_transactions_temp mmtt

6686: ,NVL(mmtt.allocated_lpn_id,
6687: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6688: ) status_id -- Onhand Material Status Support
6689: FROM
6690: mtl_material_transactions_temp mmtt
6691: WHERE
6692: mmtt.posting_flag = 'Y'
6693: AND mmtt.lot_number IS NOT NULL
6694: AND mmtt.subinventory_code IS NOT NULL

Line 6741: mtl_material_transactions_temp mmtt,

6737: ,NVL(mmtt.allocated_lpn_id,
6738: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6739: ) status_id -- Onhand Material Status Support
6740: FROM
6741: mtl_material_transactions_temp mmtt,
6742: mtl_transaction_lots_temp mtlt
6743: WHERE
6744: mmtt.posting_flag = 'Y'
6745: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 6794: mtl_material_transactions_temp mmtt

6790: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6791: )
6792: ) status_id -- Onhand Material Status Support
6793: FROM
6794: mtl_material_transactions_temp mmtt
6795: WHERE
6796: mmtt.posting_flag = 'Y'
6797: AND mmtt.lot_number IS NOT NULL
6798: AND Decode( Nvl(mmtt.transaction_status,0),

Line 6841: mtl_material_transactions_temp mmtt,

6837: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6838: )
6839: ) status_id -- Onhand Material Status Support
6840: FROM
6841: mtl_material_transactions_temp mmtt,
6842: mtl_transaction_lots_temp mtlt
6843: WHERE
6844: mmtt.posting_flag = 'Y'
6845: AND mmtt.lot_number IS NULL

Line 7109: mtl_material_transactions_temp mmtt

7105: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
7106: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7107: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7108: FROM
7109: mtl_material_transactions_temp mmtt
7110: WHERE
7111: mmtt.posting_flag = 'Y'
7112: AND mmtt.subinventory_code IS NOT NULL
7113: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 7173: mtl_material_transactions_temp mmtt

7169: , to_number(NULL) transaction_action_id
7170: , to_char(NULL) transfer_subinventory_code
7171: , to_number(NULL) transfer_locator_id
7172: FROM
7173: mtl_material_transactions_temp mmtt
7174: WHERE
7175: mmtt.posting_flag = 'Y'
7176: AND Decode( Nvl(mmtt.transaction_status,0),
7177: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 7392: mtl_material_transactions_temp mmtt

7388: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
7389: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7390: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7391: FROM
7392: mtl_material_transactions_temp mmtt
7393: WHERE
7394: mmtt.posting_flag = 'Y'
7395: AND mmtt.lot_number IS NOT NULL
7396: AND mmtt.subinventory_code IS NOT NULL

Line 7463: mtl_material_transactions_temp mmtt,

7459: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
7460: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7461: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7462: FROM
7463: mtl_material_transactions_temp mmtt,
7464: mtl_transaction_lots_temp mtlt
7465: WHERE
7466: mmtt.posting_flag = 'Y'
7467: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7526: mtl_material_transactions_temp mmtt

7522: , to_number(NULL) transaction_action_id
7523: , to_char(NULL) transfer_subinventory_code
7524: , to_number(NULL) transfer_locator_id
7525: FROM
7526: mtl_material_transactions_temp mmtt
7527: WHERE
7528: mmtt.posting_flag = 'Y'
7529: AND mmtt.lot_number IS NOT NULL
7530: AND Decode( Nvl(mmtt.transaction_status,0),

Line 7583: mtl_material_transactions_temp mmtt

7579: , to_number(NULL) transaction_action_id
7580: , to_char(NULL) transfer_subinventory_code
7581: , to_number(NULL) transfer_locator_id
7582: FROM
7583: mtl_material_transactions_temp mmtt
7584: ,mtl_transaction_lots_temp mtlt
7585: WHERE
7586: mmtt.posting_flag = 'Y'
7587: AND mmtt.lot_number IS NULL

Line 7812: mtl_material_transactions_temp mmtt

7808: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
7809: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7810: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7811: FROM
7812: mtl_material_transactions_temp mmtt
7813: WHERE
7814: mmtt.posting_flag = 'Y'
7815: AND mmtt.lot_number IS NOT NULL
7816: AND mmtt.subinventory_code IS NOT NULL

Line 7883: mtl_material_transactions_temp mmtt,

7879: , Decode(mmtt.transaction_status, 2 , mmtt.transaction_action_id, to_number(NULL)) transaction_action_id
7880: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7881: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7882: FROM
7883: mtl_material_transactions_temp mmtt,
7884: mtl_transaction_lots_temp mtlt
7885: WHERE
7886: mmtt.posting_flag = 'Y'
7887: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id

Line 7946: mtl_material_transactions_temp mmtt

7942: , to_number(NULL) transaction_action_id
7943: , to_char(NULL) transfer_subinventory_code
7944: , to_number(NULL) transfer_locator_id
7945: FROM
7946: mtl_material_transactions_temp mmtt
7947: WHERE
7948: mmtt.posting_flag = 'Y'
7949: AND mmtt.lot_number IS NOT NULL
7950: AND Decode( Nvl(mmtt.transaction_status,0),

Line 8003: mtl_material_transactions_temp mmtt

7999: , to_number(NULL) transaction_action_id
8000: , to_char(NULL) transfer_subinventory_code
8001: , to_number(NULL) transfer_locator_id
8002: FROM
8003: mtl_material_transactions_temp mmtt
8004: ,mtl_transaction_lots_temp mtlt
8005: WHERE
8006: mmtt.posting_flag = 'Y'
8007: AND mmtt.lot_number IS NULL