266: SELECT nvl(unclaim_cenvat_flag,'N'),
267: nvl(cenvat_claimed_ptg,0),
268: nvl(non_bonded_delivery_flag,'N'), --3655330
269: nvl(cenvat_amount,0) -- Bug 4516678. Added by Lakshmi Gopalsami
270: FROM JAI_RCV_CENVAT_CLAIMS
271: WHERE shipment_line_id = p_shipment_line_id;
272:
273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
269: nvl(cenvat_amount,0) -- Bug 4516678. Added by Lakshmi Gopalsami
270: FROM JAI_RCV_CENVAT_CLAIMS
271: WHERE shipment_line_id = p_shipment_line_id;
272:
273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
275: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
276: -- bug 4516678. Added by Lakshmi Gopalsami
277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
270: FROM JAI_RCV_CENVAT_CLAIMS
271: WHERE shipment_line_id = p_shipment_line_id;
272:
273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
275: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
276: -- bug 4516678. Added by Lakshmi Gopalsami
277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
278:
271: WHERE shipment_line_id = p_shipment_line_id;
272:
273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
275: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
276: -- bug 4516678. Added by Lakshmi Gopalsami
277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
278:
279: v_express VARCHAR2(100);
273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
275: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
276: -- bug 4516678. Added by Lakshmi Gopalsami
277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
278:
279: v_express VARCHAR2(100);
280: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
281: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662
1316: ===============================================================================================================
1317: Bug Number Dependency
1318: 3037075 JAI_RCV_LINE_TAXES has been altered.
1319:
1320: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1321: altered.
1322:
1323: 3123778 JAI_RCV_CENVAT_CLAIMS has been altered to add the column partial_cenvat_claim
1324:
1319:
1320: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1321: altered.
1322:
1323: 3123778 JAI_RCV_CENVAT_CLAIMS has been altered to add the column partial_cenvat_claim
1324:
1325: 4210102 IN60106 + 4239736 + 4245089
1326: ==============================================================================================================
1327: