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 4458: mtl_material_transactions_temp mmtt,

4454: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4455: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
4456: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
4457: FROM
4458: mtl_material_transactions_temp mmtt,
4459: mtl_parameters mp -- Bug 9938149
4460: WHERE
4461: mmtt.posting_flag = 'Y'
4462: AND mmtt.subinventory_code IS NOT NULL

Line 4491: mtl_material_transactions_temp mmtt

4487: , to_number(NULL) transaction_action_id
4488: , to_char(NULL) transfer_subinventory_code
4489: , to_number(NULL) transfer_locator_id
4490: FROM
4491: mtl_material_transactions_temp mmtt
4492: WHERE
4493: mmtt.posting_flag = 'Y'
4494: AND Decode( Nvl(mmtt.transaction_status,0),
4495: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 4688: mtl_material_transactions_temp mmtt,

4684: ,NVL(mmtt.allocated_lpn_id,
4685: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
4686: ) status_id -- Onhand Material Status Support
4687: FROM
4688: mtl_material_transactions_temp mmtt,
4689: mtl_parameters mp -- Bug 9938149
4690: WHERE
4691: mmtt.posting_flag = 'Y'
4692: AND mmtt.subinventory_code IS NOT NULL

Line 4742: mtl_material_transactions_temp mmtt

4738: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
4739: )
4740: ) status_id -- Onhand Material Status Support
4741: FROM
4742: mtl_material_transactions_temp mmtt
4743: WHERE
4744: mmtt.posting_flag = 'Y'
4745: AND Decode( Nvl(mmtt.transaction_status,0),
4746: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 4972: mtl_material_transactions_temp mmtt,

4968: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
4969: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
4970: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
4971: FROM
4972: mtl_material_transactions_temp mmtt,
4973: mtl_parameters mp -- Bug 9938149
4974: WHERE
4975: mmtt.posting_flag = 'Y'
4976: AND mmtt.lot_number IS NOT NULL

Line 5026: mtl_material_transactions_temp mmtt,

5022: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 5063: FROM mtl_material_transactions_temp mmtt

5059: , decode(nvl(mmtt.wms_task_status,-1), 4, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID), NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID))) lpn_id
5060: , to_number(NULL) transaction_action_id
5061: , to_char(NULL) transfer_subinventory_code
5062: , to_number(NULL) transfer_locator_id
5063: FROM mtl_material_transactions_temp mmtt
5064: WHERE mmtt.posting_flag = 'Y'
5065: AND mmtt.lot_number IS NULL
5066: AND mmtt.subinventory_code IS NOT NULL
5067: AND (mmtt.transaction_status IS NULL OR

Line 5095: mtl_material_transactions_temp mmtt

5091: , to_number(NULL) transaction_action_id
5092: , to_char(NULL) transfer_subinventory_code
5093: , to_number(NULL) transfer_locator_id
5094: FROM
5095: mtl_material_transactions_temp mmtt
5096: WHERE
5097: mmtt.posting_flag = 'Y'
5098: AND mmtt.lot_number IS NOT NULL
5099: AND Decode( Nvl(mmtt.transaction_status,0),

Line 5131: mtl_material_transactions_temp mmtt,

5127: , to_number(NULL) transaction_action_id
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

Line 5373: mtl_material_transactions_temp mmtt,

5369: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5370: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5371: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5372: FROM
5373: mtl_material_transactions_temp mmtt,
5374: mtl_parameters mp -- Bug 9938149
5375: WHERE
5376: mmtt.posting_flag = 'Y'
5377: AND mmtt.lot_number IS NOT NULL

Line 5455: mtl_material_transactions_temp mmtt,

5451: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 5526: FROM mtl_material_transactions_temp mmtt

5522: , decode(nvl(mmtt.wms_task_status,-1), 4, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID), NVL(MMTT.ALLOCATED_LPN_ID, NVL(MMTT.CONTENT_LPN_ID, MMTT.LPN_ID))) lpn_id
5523: , to_number(NULL) transaction_action_id --5698945
5524: , to_char(NULL) transfer_subinventory_code --5698945
5525: , to_number(NULL) transfer_locator_id --5698945
5526: FROM mtl_material_transactions_temp mmtt
5527: WHERE mmtt.posting_flag = 'Y'
5528: AND mmtt.lot_number IS NULL
5529: AND mmtt.subinventory_code IS NOT NULL
5530: AND (mmtt.transaction_status IS NULL OR

Line 5586: mtl_material_transactions_temp mmtt

5582: , to_number(NULL) transaction_action_id
5583: , to_char(NULL) transfer_subinventory_code
5584: , to_number(NULL) transfer_locator_id
5585: FROM
5586: mtl_material_transactions_temp mmtt
5587: WHERE
5588: mmtt.posting_flag = 'Y'
5589: AND mmtt.lot_number IS NOT NULL
5590: AND Decode( Nvl(mmtt.transaction_status,0),

Line 5651: mtl_material_transactions_temp mmtt

5647: , to_number(NULL) transaction_action_id
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

Line 5842: mtl_material_transactions_temp mmtt,

5838: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
5839: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
5840: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
5841: FROM
5842: mtl_material_transactions_temp mmtt,
5843: mtl_parameters mp -- Bug 9938149
5844: WHERE
5845: mmtt.posting_flag = 'Y'
5846: AND mmtt.lot_number IS NOT NULL

Line 5896: mtl_material_transactions_temp mmtt,

5892: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 5933: mtl_material_transactions_temp mmtt

5929: , to_number(NULL) transaction_action_id
5930: , to_char(NULL) transfer_subinventory_code
5931: , to_number(NULL) transfer_locator_id
5932: FROM
5933: mtl_material_transactions_temp mmtt
5934: WHERE
5935: mmtt.posting_flag = 'Y'
5936: AND mmtt.lot_number IS NOT NULL
5937: AND Decode( Nvl(mmtt.transaction_status,0),

Line 5971: mtl_material_transactions_temp mmtt,

5967: , to_number(NULL) transaction_action_id
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

Line 6169: mtl_material_transactions_temp mmtt

6165: ,NVL(mmtt.allocated_lpn_id,
6166: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6167: ) status_id -- Onhand Material Status Support
6168: FROM
6169: mtl_material_transactions_temp mmtt
6170: , mtl_parameters mp -- Bug 9938149
6171: WHERE
6172: mmtt.posting_flag = 'Y'
6173: -- invConv bug 4074394 removed the fix in v115.141, because it only works

Line 6234: mtl_material_transactions_temp mmtt,

6230: ,NVL(mmtt.allocated_lpn_id,
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'

Line 6277: mtl_material_transactions_temp mmtt

6273: ,NULL --lot number
6274: ,NVL(mmtt.allocated_lpn_id,NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6275: ) status_id -- Onhand Material Status Support
6276: FROM
6277: mtl_material_transactions_temp mmtt
6278: WHERE mmtt.posting_flag = 'Y'
6279: AND mmtt.lot_number IS NULL
6280: AND mmtt.subinventory_code IS NOT NULL
6281: AND (mmtt.transaction_status IS NULL OR

Line 6328: mtl_material_transactions_temp mmtt

6324: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6325: )
6326: ) status_id -- Onhand Material Status Support
6327: FROM
6328: mtl_material_transactions_temp mmtt
6329: WHERE
6330: mmtt.posting_flag = 'Y'
6331: AND mmtt.lot_number IS NOT NULL
6332: AND Decode( Nvl(mmtt.transaction_status,0),

Line 6383: mtl_material_transactions_temp mmtt,

6379: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
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

Line 6612: mtl_material_transactions_temp mmtt

6608: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
6609: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
6610: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
6611: FROM
6612: mtl_material_transactions_temp mmtt
6613: , mtl_parameters mp -- Bug 9938149
6614: WHERE
6615: mmtt.posting_flag = 'Y'
6616: AND mmtt.lot_number IS NOT NULL

Line 6666: mtl_material_transactions_temp mmtt,

6662: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 6703: mtl_material_transactions_temp mmtt

6699: , to_number(NULL) transaction_action_id
6700: , to_char(NULL) transfer_subinventory_code
6701: , to_number(NULL) transfer_locator_id
6702: FROM
6703: mtl_material_transactions_temp mmtt
6704: WHERE
6705: mmtt.posting_flag = 'Y'
6706: AND mmtt.lot_number IS NOT NULL
6707: AND Decode( Nvl(mmtt.transaction_status,0),

Line 6740: mtl_material_transactions_temp mmtt,

6736: , to_number(NULL) transaction_action_id
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

Line 6939: mtl_material_transactions_temp mmtt

6935: ,NVL(mmtt.allocated_lpn_id,
6936: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
6937: ) status_id -- Onhand Material Status Support
6938: FROM
6939: mtl_material_transactions_temp mmtt
6940: , mtl_parameters mp -- Bug 9938149
6941: WHERE
6942: mmtt.posting_flag = 'Y'
6943: AND mmtt.lot_number IS NOT NULL

Line 7001: mtl_material_transactions_temp mmtt,

6997: ,NVL(mmtt.allocated_lpn_id,
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'

Line 7056: mtl_material_transactions_temp mmtt

7052: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
7053: )
7054: ) status_id -- Onhand Material Status Support
7055: FROM
7056: mtl_material_transactions_temp mmtt
7057: WHERE
7058: mmtt.posting_flag = 'Y'
7059: AND mmtt.lot_number IS NOT NULL
7060: AND Decode( Nvl(mmtt.transaction_status,0),

Line 7111: mtl_material_transactions_temp mmtt,

7107: NVL(mmtt.content_lpn_id, mmtt.lpn_id))
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

Line 7394: mtl_material_transactions_temp mmtt

7390: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
7391: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7392: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7393: FROM
7394: mtl_material_transactions_temp mmtt
7395: , mtl_parameters mp -- Bug 9938149
7396: WHERE
7397: mmtt.posting_flag = 'Y'
7398: AND mmtt.subinventory_code IS NOT NULL

Line 7460: mtl_material_transactions_temp mmtt

7456: , to_number(NULL) transaction_action_id
7457: , to_char(NULL) transfer_subinventory_code
7458: , to_number(NULL) transfer_locator_id
7459: FROM
7460: mtl_material_transactions_temp mmtt
7461: WHERE
7462: mmtt.posting_flag = 'Y'
7463: AND Decode( Nvl(mmtt.transaction_status,0),
7464: 2, decode(nvl(mmtt.wms_task_status,-1), 4, 1, 2),

Line 7697: mtl_material_transactions_temp mmtt

7693: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
7694: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
7695: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
7696: FROM
7697: mtl_material_transactions_temp mmtt
7698: , mtl_parameters mp -- Bug 9938149
7699: WHERE
7700: mmtt.posting_flag = 'Y'
7701: AND mmtt.lot_number IS NOT NULL

Line 7779: mtl_material_transactions_temp mmtt,

7775: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 7844: mtl_material_transactions_temp mmtt

7840: , to_number(NULL) transaction_action_id
7841: , to_char(NULL) transfer_subinventory_code
7842: , to_number(NULL) transfer_locator_id
7843: FROM
7844: mtl_material_transactions_temp mmtt
7845: WHERE
7846: mmtt.posting_flag = 'Y'
7847: AND mmtt.lot_number IS NOT NULL
7848: AND Decode( Nvl(mmtt.transaction_status,0),

Line 7909: mtl_material_transactions_temp mmtt

7905: , to_number(NULL) transaction_action_id
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

Line 8153: mtl_material_transactions_temp mmtt

8149: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
8150: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_subinventory, to_char(NULL)) transfer_subinventory_code
8151: , Decode(mmtt.transaction_status, 2 , mmtt.transfer_to_location, to_number(NULL)) transfer_locator_id
8152: FROM
8153: mtl_material_transactions_temp mmtt
8154: , mtl_parameters mp -- Bug 9938149
8155: WHERE
8156: mmtt.posting_flag = 'Y'
8157: AND mmtt.lot_number IS NOT NULL

Line 8235: mtl_material_transactions_temp mmtt,

8231: mmtt.transaction_action_id), to_number(NULL)) transaction_action_id
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'

Line 8300: mtl_material_transactions_temp mmtt

8296: , to_number(NULL) transaction_action_id
8297: , to_char(NULL) transfer_subinventory_code
8298: , to_number(NULL) transfer_locator_id
8299: FROM
8300: mtl_material_transactions_temp mmtt
8301: WHERE
8302: mmtt.posting_flag = 'Y'
8303: AND mmtt.lot_number IS NOT NULL
8304: AND Decode( Nvl(mmtt.transaction_status,0),

Line 8365: mtl_material_transactions_temp mmtt

8361: , to_number(NULL) transaction_action_id
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