APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_SUP_LINES

Line 810: FROM JAI_AR_SUP_LINES A,

806: SELECT DISTINCT A.tax_category_id,
807: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
808: NVL(A.excise_diff_amt,0) excise_diff,
809: A.new_assessable_value
810: FROM JAI_AR_SUP_LINES A,
811: ra_customer_trx_all b,
812: ra_cust_trx_types_all c
813: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
814: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')

Line 822: FROM JAI_AR_SUP_LINES A,

818: CURSOR SUPPLEMENT_LINES_INFO_CNSLDT IS
819: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
820: NVL(A.excise_diff_amt,0) excise_diff,
821: A.new_assessable_value
822: FROM JAI_AR_SUP_LINES A,
823: JAI_AR_SUP_HDRS_ALL b,
824: ra_customer_trx_all c,
825: ra_cust_trx_types_all e
826: WHERE pr_new.customer_trx_id = c.customer_trx_id

Line 839: FROM JAI_AR_SUP_LINES A,

835: b.supp_inv_type;
836:
837: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
838: SELECT A.tax_category_id
839: FROM JAI_AR_SUP_LINES A,
840: JAI_AR_SUP_HDRS_ALL b,
841: ra_customer_trx_all c,
842: ra_cust_trx_types_all D
843: WHERE pr_new.customer_trx_id = c.customer_trx_id

Line 907: JAI_AR_SUP_LINES b,

903: A.diff_amt FUNC_TAX_AMT,
904: t.tax_type,
905: t.stform_type
906: FROM JAI_AR_SUP_TAXES A,
907: JAI_AR_SUP_LINES b,
908: ra_customer_trx_all C,
909: ra_cust_trx_types_all D,
910: JAI_CMN_TAXES_ALL t
911: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id

Line 931: JAI_AR_SUP_LINES b,

927: SUM(A.diff_amt) FUNC_TAX_AMT,
928: t.tax_type,
929: t.stform_type
930: FROM JAI_AR_SUP_TAXES A,
931: JAI_AR_SUP_LINES b,
932: JAI_AR_SUP_HDRS_ALL c,
933: ra_customer_trx_all D,
934: ra_cust_trx_types_all e,
935: JAI_CMN_TAXES_ALL t

Line 976: FROM JAI_AR_SUP_LINES

972:
973:
974: CURSOR SUPPLEMENT_LINES_CHECK IS
975: SELECT 1
976: FROM JAI_AR_SUP_LINES
977: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
978: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
979: SELECT 1
980: FROM JAI_AR_SUP_LINES A,

Line 980: FROM JAI_AR_SUP_LINES A,

976: FROM JAI_AR_SUP_LINES
977: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
978: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
979: SELECT 1
980: FROM JAI_AR_SUP_LINES A,
981: JAI_AR_SUP_HDRS_ALL B,
982: RA_CUSTOMER_TRX_ALL C,
983: RA_CUST_TRX_TYPES_ALL D
984: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id

Line 1001: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b

997: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
998:
999: CURSOR SUPPLEMENT_TAX_LINES_CHECK IS
1000: SELECT 1
1001: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b
1002: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
1003: AND b.customer_trx_line_id = v_customer_Trx_line_id;
1004:
1005: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS

Line 1007: FROM JAI_AR_SUP_LINES A,

1003: AND b.customer_trx_line_id = v_customer_Trx_line_id;
1004:
1005: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1006: SELECT 1
1007: FROM JAI_AR_SUP_LINES A,
1008: JAI_AR_SUP_HDRS_ALL B,
1009: RA_CUSTOMER_TRX_ALL C,
1010: RA_CUST_TRX_TYPES_ALL D,
1011: JAI_AR_SUP_TAXES E