DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on JAI_RCV_CENVAT_CLAIMS

Line 270: FROM JAI_RCV_CENVAT_CLAIMS

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;

Line 273: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%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;

Line 274: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%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:

Line 275: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;

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);

Line 277: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;

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

Line 1320: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been

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:

Line 1323: 3123778 JAI_RCV_CENVAT_CLAIMS has been altered to add the column partial_cenvat_claim

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: