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.inventory_item_id = d.inventory_item_id
702: AND a.shipment_header_id = v_shipment_header_id

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

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