DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on JAI_RCV_CENVAT_CLAIMS

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

Line 2413: JAI_RCV_CENVAT_CLAIMS b,/*bgowrava for forward porting bug#5674376*/

2409: v_statement_no := '1.4';
2410: FOR line IN ( SELECT a.shipment_line_id, a.transaction_id, a.item_class,
2411: a.transaction_type, a.parent_transaction_type, a.quantity
2412: FROM JAI_RCV_TRANSACTIONS a,
2413: JAI_RCV_CENVAT_CLAIMS b,/*bgowrava for forward porting bug#5674376*/
2414: RCV_TRANSACTIONS c,/*bgowrava for forward porting bug#5674376*/
2415: jai_rcv_rtv_batch_trxs d
2416: -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh. WHERE a.shipment_header_id = v_shipment_header_id
2417: WHERE a.transaction_id = d.transaction_id -- Vijay Shankar for Bug#4346453. RCV DFF Elim. Enh.