APPS.JAI_AR_IMPORT_POPU_PKG dependencies on JAI_AR_SUP_LINES

Line 2991: FROM JAI_AR_SUP_LINES A,

2987: WHERE customer_trx_id = pr_new.customer_trx_id;
2988:
2989: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
2990: SELECT 1
2991: FROM JAI_AR_SUP_LINES A,
2992: JAI_AR_SUP_HDRS_ALL B,
2993: RA_CUSTOMER_TRX_ALL C,
2994: RA_CUST_TRX_TYPES_ALL D
2995: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id

Line 3004: FROM JAI_AR_SUP_LINES

3000: AND A.customer_trx_id = b.customer_trx_id;
3001:
3002: CURSOR SUPPLEMENT_LINES_CHECK IS
3003: SELECT 1
3004: FROM JAI_AR_SUP_LINES
3005: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
3006:
3007: CURSOR JA_IN_RA_CUSTOMER_TRX_INFOCNSL IS
3008: SELECT A.organization_id,

Line 3034: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b

3030: v_customer_trx_line_id NUMBER;
3031:
3032: CURSOR SUPPLEMENT_TAX_LINES_CHECK IS
3033: SELECT 1
3034: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b
3035: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
3036: AND b.customer_trx_line_id = v_customer_Trx_line_id;
3037:
3038: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS

Line 3040: FROM JAI_AR_SUP_LINES A,

3036: AND b.customer_trx_line_id = v_customer_Trx_line_id;
3037:
3038: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
3039: SELECT 1
3040: FROM JAI_AR_SUP_LINES A,
3041: JAI_AR_SUP_HDRS_ALL B,
3042: RA_CUSTOMER_TRX_ALL C,
3043: RA_CUST_TRX_TYPES_ALL D,
3044: JAI_AR_SUP_TAXES E

Line 3066: JAI_AR_SUP_LINES b,

3062: A.diff_amt FUNC_TAX_AMT,
3063: t.tax_type,
3064: t.stform_type
3065: FROM JAI_AR_SUP_TAXES A,
3066: JAI_AR_SUP_LINES b,
3067: ra_customer_trx_all C,
3068: ra_cust_trx_types_all D,
3069: JAI_CMN_TAXES_ALL t
3070: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id

Line 3090: JAI_AR_SUP_LINES b,

3086: SUM(A.diff_amt) FUNC_TAX_AMT,
3087: t.tax_type,
3088: t.stform_type
3089: FROM JAI_AR_SUP_TAXES A,
3090: JAI_AR_SUP_LINES b,
3091: JAI_AR_SUP_HDRS_ALL c,
3092: ra_customer_trx_all D,
3093: ra_cust_trx_types_all e,
3094: JAI_CMN_TAXES_ALL t

Line 3132: FROM JAI_AR_SUP_LINES A,

3128: SELECT DISTINCT A.tax_category_id,
3129: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
3130: NVL(A.excise_diff_amt,0) excise_diff,
3131: A.new_assessable_value
3132: FROM JAI_AR_SUP_LINES A,
3133: ra_customer_trx_all b,
3134: ra_cust_trx_types_all c
3135: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
3136: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')

Line 3144: FROM JAI_AR_SUP_LINES A,

3140: CURSOR SUPPLEMENT_LINES_INFO_CNSLDT IS
3141: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
3142: NVL(A.excise_diff_amt,0) excise_diff,
3143: A.new_assessable_value
3144: FROM JAI_AR_SUP_LINES A,
3145: JAI_AR_SUP_HDRS_ALL b,
3146: ra_customer_trx_all c,
3147: ra_cust_trx_types_all e
3148: WHERE pr_new.customer_trx_id = c.customer_trx_id

Line 3162: FROM JAI_AR_SUP_LINES A,

3158: NVL(A.excise_diff_amt,0);
3159:
3160: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
3161: SELECT A.tax_category_id
3162: FROM JAI_AR_SUP_LINES A,
3163: JAI_AR_SUP_HDRS_ALL b,
3164: ra_customer_trx_all c,
3165: ra_cust_trx_types_all D
3166: WHERE pr_new.customer_trx_id = c.customer_trx_id