DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on JAI_INV_ITM_SETUPS

Line 698: FROM JAI_RCV_LINES a,JAI_RCV_CENVAT_CLAIMS b,RCV_TRANSACTIONS c, JAI_INV_ITM_SETUPS d

694:
695: v_statement_no := '1.4';
696: -- this is to get RECEIVE type of transactions
697: FOR line IN ( SELECT a.shipment_line_id, a.transaction_id, d.item_class
698: FROM JAI_RCV_LINES a,JAI_RCV_CENVAT_CLAIMS b,RCV_TRANSACTIONS c, JAI_INV_ITM_SETUPS d
699: WHERE a.organization_id = d.organization_id
700: AND b.transaction_id = a.transaction_id /*bgowrava for forward porting bug#5674376*/
701: AND a.transaction_id = c.transaction_id --Added by nprashar for bug # 13367420
702: AND a.inventory_item_id = d.inventory_item_id