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.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_INV_SUBINV_DTLS

Line 4579: SELECT organization_id , location_id FROM JAI_INV_SUBINV_DTLS

4575: -- following cursor added by sriram -- bug # 2755890 to pick up the
4576: -- organization and location id based on the subinventory name
4577:
4578: Cursor c_get_location is
4579: SELECT organization_id , location_id FROM JAI_INV_SUBINV_DTLS
4580: WHERE organization_id = pr_new.interface_line_attribute10
4581: AND UPPER(sub_inventory_name) IN
4582: (SELECT UPPER(subinventory)
4583: FROM rcv_transactions

Line 5367: to fetch the organization id , location id based on the subinventory name from the JAI_INV_SUBINV_DTLS

5363: cursor definition has been corrected .
5364:
5365: For RMA without reference , organization and location has to be fetched based on the subinventory
5366: chosen in the receiving transaction in Purchasing responsibility. Hence a new cursor is written
5367: to fetch the organization id , location id based on the subinventory name from the JAI_INV_SUBINV_DTLS
5368: table based on the subinventory name in the rcv transactions table.
5369:
5370: 7. 2003/04/18 Sriram - Bug # 2905912 - File Version 615.4
5371: For a RMA Transaction , the tax amount and total amount columns in the JAI_AR_TRXS