APPS.JAI_AR_IMPORT_POPU_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 2994: RA_CUST_TRX_TYPES_ALL D

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
2996: AND c.cust_trx_type_id = D.cust_trx_type_id
2997: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)
2998: AND b.supp_inv_type = DECODE(D.TYPE,'INV','SI','CM','CR','DM','DB')

Line 3043: RA_CUST_TRX_TYPES_ALL D,

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
3045: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id
3046: AND c.cust_trx_type_id = D.cust_trx_type_id
3047: AND c.trx_number = TO_CHAR(b.SUPPLEMENTARY_NUM)

Line 3068: ra_cust_trx_types_all D,

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
3071: AND A.sup_inv_type = b.sup_inv_type
3072: AND b.customer_Trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)

Line 3093: ra_cust_trx_types_all e,

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
3095: WHERE pr_new.customer_trx_id = D.customer_trx_id
3096: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
3097: AND c.customer_trx_id = b.customer_trx_id

Line 3134: ra_cust_trx_types_all c

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')
3137: AND A.customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3)
3138: AND pr_new.customer_trx_id = b.customer_trx_id;

Line 3147: ra_cust_trx_types_all e

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
3149: AND c.trx_number = TO_CHAR( b.SUPPLEMENTARY_NUM)
3150: AND B.customer_trx_id = A.customer_trx_id
3151: AND C.cust_trx_type_id = e.cust_trx_type_id

Line 3165: ra_cust_trx_types_all D

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
3167: AND c.trx_number =TO_CHAR( b.SUPPLEMENTARY_NUM)
3168: AND B.customer_trx_id = A.customer_trx_id
3169: AND A.sup_inv_type = b.supp_inv_type

Line 4378: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4374: v_trans_type VARCHAR2(30);
4375:
4376: CURSOR transaction_type_cur IS
4377: SELECT A.TYPE
4378: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4379: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4380: AND b.customer_trx_id = v_header_id
4381: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4382:

Line 4911: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4907:
4908: v_trans_type VARCHAR2(30);
4909: CURSOR transaction_type_cur IS
4910: SELECT A.TYPE
4911: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4912: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4913: AND b.customer_trx_id = v_header_id
4914: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4915:

Line 6247: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6243:
6244: -- cursor to get transaction type
6245: CURSOR c_transaction_type IS
6246: SELECT A.TYPE
6247: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6248: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6249: AND b.customer_trx_id = r_new.customer_trx_id
6250: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6251: