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.

[Home] [Help]

APPS.INV_UOM_API_PUB dependencies on GME_TRANSACTION_PAIRS

Line 1859: FROM gme_transaction_pairs

1855: AND t.organization_id = p_org_id
1856: AND T.TRANSACTION_SOURCE_TYPE_ID = 5
1857: AND NOT EXISTS
1858: (SELECT transaction_id1
1859: FROM gme_transaction_pairs
1860: WHERE transaction_id1 = t.transaction_id
1861: AND pair_type = 1
1862: )
1863: AND l.transaction_id = t.transaction_id

Line 1902: FROM gme_transaction_pairs

1898: WHERE mmt.transaction_source_id = L_BATCH_ID
1899: AND mmt.transaction_source_type_id = 5
1900: AND NOT EXISTS
1901: (SELECT transaction_id1
1902: FROM gme_transaction_pairs
1903: WHERE transaction_id1 = mmt.transaction_id
1904: AND pair_type = 1
1905: )
1906: AND mmt.inventory_item_id = p_item_id