DBA Data[Home] [Help]

APPS.JAI_RCV_RND_PKG dependencies on JAI_RCV_LINES

Line 191: FROM JAI_RCV_LINES

187:
188: ln_receive_qty NUMBER;
189: CURSOR c_ja_in_receive_qty(cp_shipment_line_id IN NUMBER) IS
190: SELECT qty_received
191: FROM JAI_RCV_LINES
192: WHERE shipment_line_id = cp_shipment_line_id;
193:
194: --Added the below 2 by Sanjikum for Bug #4049363
195: ln_cenvat_amount AMOUNT_RECORD;

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 2060: FROM JAI_RCV_LINES

2056:
2057: ln_receive_qty NUMBER;
2058: CURSOR c_ja_in_receive_qty(cp_shipment_line_id IN NUMBER) IS
2059: SELECT qty_received
2060: FROM JAI_RCV_LINES
2061: WHERE shipment_line_id = cp_shipment_line_id;
2062:
2063: --Added the below 2 by Sanjikum for Bug #4049363
2064: ln_cenvat_amount AMOUNT_RECORD;