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.AHL_PRD_MTLTXN_PVT dependencies on CSI_TRANSACTIONS

Line 2254: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);

2250: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
2251: AND mmt.Transaction_Type_Id = p_type_id
2252: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')
2253: AND mtln.lot_number = p_lot_number
2254: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);
2255:
2256: -- pending txns for item that is not lot controlled..
2257: CURSOR csi_pending_txns_csr (p_wip_entity_id IN NUMBER,
2258: p_inventory_item_id IN NUMBER,

Line 2268: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);

2264: WHERE mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
2265: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
2266: AND mmt.Transaction_Type_Id = p_type_id
2267: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')
2268: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);
2269:
2270: -- validate serial number in msn for return txns.
2271: CURSOR mtl_serial_csr (p_inv_item_id IN NUMBER,
2272: p_serial_num IN VARCHAR2)

Line 5210: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);

5206: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
5207: AND mmt.Transaction_Type_Id = p_type_id
5208: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')
5209: AND mtln.lot_number = p_lot_number
5210: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);
5211:
5212: -- check pending txns for non-lot items.
5213: CURSOR csi_pending_txn (p_wip_entity_id IN NUMBER,
5214: p_inventory_item_id IN NUMBER,

Line 5225: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);

5221: WHERE mmt.TRANSACTION_SOURCE_ID = p_wip_entity_id
5222: AND mmt.INVENTORY_ITEM_ID = p_inventory_item_id
5223: AND mmt.Transaction_Type_Id = p_type_id
5224: AND nvl(mmt.revision, '1') = nvl(p_item_revision, '1')
5225: AND NOT EXISTS (select 'x' from csi_transactions where INV_MATERIAL_TRANSACTION_ID = mmt.TRANSACTION_ID);
5226:
5227: BEGIN
5228: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL)THEN
5229: fnd_log.string