DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 4252: FROM rcv_transactions

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
4253: WHERE
4254: organization_id = pr_new.interface_line_attribute10
4255: AND (oe_order_line_id) = v_interface_line_attribute7
4256: AND subinventory IS NOT NULL

Line 4414: table based on the subinventory name in the rcv transactions table.

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
4418: table were incorrect. This has been corrected in this fix.