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_PARAMETERS

Line 4459: mtl_parameters mp -- Bug 9938149

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
4463: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 4689: mtl_parameters mp -- Bug 9938149

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
4693: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 4771: , mtl_parameters mp -- Onhand Material Status Support

4767: , x.transfer_locator_id, x.status_id -- Onhand Material Status Support
4768: ) x
4769: , mtl_secondary_inventories sub
4770: , mtl_item_locations loc
4771: , mtl_parameters mp -- Onhand Material Status Support
4772: , mtl_material_statuses_b mms -- Onhand Material Status Support
4773: WHERE
4774: x.organization_id = loc.organization_id (+)
4775: AND x.locator_id = loc.inventory_location_id (+)

Line 4973: mtl_parameters mp -- Bug 9938149

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
4977: AND mmtt.subinventory_code IS NOT NULL

Line 5028: mtl_parameters mp -- Bug 9938149

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
5032: AND mmtt.lot_number IS NULL

Line 5374: mtl_parameters mp -- Bug 9938149

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
5378: AND mmtt.subinventory_code IS NOT NULL

Line 5457: mtl_parameters mp -- bug 9938149

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
5461: AND mmtt.lot_number IS NULL

Line 5843: mtl_parameters mp -- Bug 9938149

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
5847: AND mmtt.subinventory_code IS NOT NULL

Line 5898: mtl_parameters mp -- Bug 9938149

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
5902: AND mmtt.lot_number IS NULL

Line 6170: , mtl_parameters mp -- Bug 9938149

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
6174: -- when the ingredient item has no inventory.

Line 6236: , mtl_parameters mp -- Bug 9938149

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
6240: AND mmtt.lot_number IS NULL

Line 6414: , mtl_parameters mp -- Onhand Material Status Support

6410: ) x
6411: , mtl_secondary_inventories sub
6412: , mtl_item_locations loc
6413: , mtl_lot_numbers lot
6414: , mtl_parameters mp -- Onhand Material Status Support
6415: , mtl_material_statuses_b mms -- Onhand Material Status Support
6416: WHERE
6417: x.inventory_item_id = lot.inventory_item_id (+)
6418: AND x.organization_id = lot.organization_id (+)

Line 6613: , mtl_parameters mp -- Bug 9938149

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
6617: AND mmtt.subinventory_code IS NOT NULL

Line 6668: , mtl_parameters mp -- Bug 9938149

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
6672: AND mmtt.lot_number IS NULL

Line 6940: , mtl_parameters mp -- Bug 9938149

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
6944: AND mmtt.subinventory_code IS NOT NULL

Line 7003: , mtl_parameters mp -- Bug 9938149

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
7007: AND mmtt.lot_number IS NULL

Line 7142: , mtl_parameters mp -- Onhand Material Status Support

7138: ) x
7139: , mtl_secondary_inventories sub
7140: , mtl_item_locations loc
7141: , mtl_lot_numbers lot
7142: , mtl_parameters mp -- Onhand Material Status Support
7143: , mtl_material_statuses_b mms -- Onhand Material Status Support
7144: WHERE
7145: x.inventory_item_id = lot.inventory_item_id (+)
7146: AND x.organization_id = lot.organization_id (+)

Line 7395: , mtl_parameters mp -- Bug 9938149

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
7399: AND (Nvl(mmtt.transaction_status,0) <> 2 OR

Line 7698: , mtl_parameters mp -- Bug 9938149

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
7702: AND mmtt.subinventory_code IS NOT NULL

Line 7781: , mtl_parameters mp -- Bug 9938149

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
7785: AND mmtt.lot_number IS NULL

Line 8154: , mtl_parameters mp -- Bug 9938149

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
8158: AND mmtt.subinventory_code IS NOT NULL

Line 8237: , mtl_parameters mp -- Bug 9938149

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
8241: AND mmtt.lot_number IS NULL