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 4248: SELECT organization_id , location_id FROM JAI_INV_SUBINV_DTLS

4244: -- following cursor added by sriram -- bug # 2755890 to pick up the
4245: -- organization and location id based on the subinventory name
4246:
4247: Cursor c_get_location is
4248: SELECT organization_id , location_id FROM JAI_INV_SUBINV_DTLS
4249: WHERE organization_id = pr_new.interface_line_attribute10
4250: AND UPPER(sub_inventory_name) IN
4251: (SELECT UPPER(subinventory)
4252: FROM rcv_transactions

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

4409: cursor definition has been corrected .
4410:
4411: For RMA without reference , organization and location has to be fetched based on the subinventory
4412: chosen in the receiving transaction in Purchasing responsibility. Hence a new cursor is written
4413: to fetch the organization id , location id based on the subinventory name from the JAI_INV_SUBINV_DTLS
4414: table based on the subinventory name in the rcv transactions table.
4415:
4416: 7. 2003/04/18 Sriram - Bug # 2905912 - File Version 615.4
4417: For a RMA Transaction , the tax amount and total amount columns in the JAI_AR_TRXS