DBA Data[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on JAI_RCV_CENVAT_CLAIMS

Line 292: FROM JAI_RCV_CENVAT_CLAIMS

288: SELECT nvl(unclaim_cenvat_flag,'N'),
289: nvl(cenvat_claimed_ptg,0),
290: nvl(non_bonded_delivery_flag,'N'), --3655330
291: nvl(cenvat_amount,0) -- Bug 4516678. Added by Lakshmi Gopalsami
292: FROM JAI_RCV_CENVAT_CLAIMS
293: WHERE shipment_line_id = p_shipment_line_id;
294:
295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;

Line 295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;

291: nvl(cenvat_amount,0) -- Bug 4516678. Added by Lakshmi Gopalsami
292: FROM JAI_RCV_CENVAT_CLAIMS
293: WHERE shipment_line_id = p_shipment_line_id;
294:
295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
297: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
298: -- bug 4516678. Added by Lakshmi Gopalsami
299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;

Line 296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;

292: FROM JAI_RCV_CENVAT_CLAIMS
293: WHERE shipment_line_id = p_shipment_line_id;
294:
295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
297: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
298: -- bug 4516678. Added by Lakshmi Gopalsami
299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
300:

Line 297: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;

293: WHERE shipment_line_id = p_shipment_line_id;
294:
295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
297: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
298: -- bug 4516678. Added by Lakshmi Gopalsami
299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
300:
301: v_express VARCHAR2(100);

Line 299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;

295: v_unclaim_cenvat_flag JAI_RCV_CENVAT_CLAIMS.unclaim_cenvat_flag%type;
296: v_cenvat_claimed_ptg JAI_RCV_CENVAT_CLAIMS.cenvat_claimed_ptg%type;
297: v_non_bonded_delivery_flag JAI_RCV_CENVAT_CLAIMS.non_bonded_delivery_flag%type;
298: -- bug 4516678. Added by Lakshmi Gopalsami
299: v_cenvat_amount JAI_RCV_CENVAT_CLAIMS.cenvat_amount%type;
300:
301: v_express VARCHAR2(100);
302: v_shipment_num rcv_shipment_headers.shipment_num%type; -- ssumaith - bug# 3657662
303: v_order_header_id oe_order_headers_all.header_id%type; -- ssumaith - bug# 3657662

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

1521: ===============================================================================================================
1522: Bug Number Dependency
1523: 3037075 JAI_RCV_LINE_TAXES has been altered.
1524:
1525: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1526: altered.
1527:
1528: 3123778 JAI_RCV_CENVAT_CLAIMS has been altered to add the column partial_cenvat_claim
1529:

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

1524:
1525: 3057752 Tables : JAI_RCV_CENVAT_CLAIMS, ja_in_temp_mod_params, ja_in_batch_claim_modvat have been
1526: altered.
1527:
1528: 3123778 JAI_RCV_CENVAT_CLAIMS has been altered to add the column partial_cenvat_claim
1529:
1530: 4210102 IN60106 + 4239736 + 4245089
1531: ==============================================================================================================
1532: