APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_SUP_LINES

Line 876: FROM JAI_AR_SUP_LINES A,

872: SELECT DISTINCT A.tax_category_id,
873: (NVL(A.excise_diff_amt,0)+NVL(A.other_diff_amt,0)) TAX_AMT,
874: NVL(A.excise_diff_amt,0) excise_diff,
875: A.new_assessable_value
876: FROM JAI_AR_SUP_LINES A,
877: ra_customer_trx_all b,
878: ra_cust_trx_types_all c
879: WHERE B.CUST_TRX_TYPE_ID = C.CUST_TRX_TYPE_ID
880: AND A.SUP_INV_TYPE = DECODE(C.TYPE,'DM','DB','CM','CR','INV','SI')

Line 888: FROM JAI_AR_SUP_LINES A,

884: CURSOR SUPPLEMENT_LINES_INFO_CNSLDT IS
885: SELECT SUM(NVL(A.excise_diff_amt,0))+SUM(NVL(A.other_diff_amt,0)) TAX_AMT,
886: NVL(A.excise_diff_amt,0) excise_diff,
887: A.new_assessable_value
888: FROM JAI_AR_SUP_LINES A,
889: JAI_AR_SUP_HDRS_ALL b,
890: ra_customer_trx_all c,
891: ra_cust_trx_types_all e
892: WHERE pr_new.customer_trx_id = c.customer_trx_id

Line 907: FROM JAI_AR_SUP_LINES A,

903: ;
904:
905: CURSOR SUPPLEMENT_LINES_INFO_Tax_catg IS
906: SELECT A.tax_category_id
907: FROM JAI_AR_SUP_LINES A,
908: JAI_AR_SUP_HDRS_ALL b,
909: ra_customer_trx_all c,
910: ra_cust_trx_types_all D
911: WHERE pr_new.customer_trx_id = c.customer_trx_id

Line 975: JAI_AR_SUP_LINES b,

971: A.diff_amt FUNC_TAX_AMT,
972: t.tax_type,
973: t.stform_type
974: FROM JAI_AR_SUP_TAXES A,
975: JAI_AR_SUP_LINES b,
976: ra_customer_trx_all C,
977: ra_cust_trx_types_all D,
978: JAI_CMN_TAXES_ALL t
979: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id

Line 999: JAI_AR_SUP_LINES b,

995: SUM(A.diff_amt) FUNC_TAX_AMT,
996: t.tax_type,
997: t.stform_type
998: FROM JAI_AR_SUP_TAXES A,
999: JAI_AR_SUP_LINES b,
1000: JAI_AR_SUP_HDRS_ALL c,
1001: ra_customer_trx_all D,
1002: ra_cust_trx_types_all e,
1003: JAI_CMN_TAXES_ALL t

Line 1044: FROM JAI_AR_SUP_LINES

1040:
1041:
1042: CURSOR SUPPLEMENT_LINES_CHECK IS
1043: SELECT 1
1044: FROM JAI_AR_SUP_LINES
1045: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
1046: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
1047: SELECT 1
1048: FROM JAI_AR_SUP_LINES A,

Line 1048: FROM JAI_AR_SUP_LINES A,

1044: FROM JAI_AR_SUP_LINES
1045: WHERE customer_trx_line_id = TO_NUMBER(pr_new.interface_line_attribute3);
1046: CURSOR SUPPLEMENT_LINES_CHECK_CNSLDT IS
1047: SELECT 1
1048: FROM JAI_AR_SUP_LINES A,
1049: JAI_AR_SUP_HDRS_ALL B,
1050: RA_CUSTOMER_TRX_ALL C,
1051: RA_CUST_TRX_TYPES_ALL D
1052: WHERE pr_new.CUSTOMER_TRX_ID = C.customer_trx_id

Line 1069: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b

1065: AND b.order_line_id = TO_NUMBER(v_interface_line_attribute6); --17-Apr-2002
1066:
1067: CURSOR SUPPLEMENT_TAX_LINES_CHECK IS
1068: SELECT 1
1069: FROM JAI_AR_SUP_TAXES A, JAI_AR_SUP_LINES b
1070: WHERE A.link_to_cust_trx_line_id = b.customer_trx_line_id
1071: AND b.customer_trx_line_id = v_customer_Trx_line_id;
1072:
1073: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS

Line 1075: FROM JAI_AR_SUP_LINES A,

1071: AND b.customer_trx_line_id = v_customer_Trx_line_id;
1072:
1073: CURSOR SUPPLEMENT_TAX_LINES_CHECK_CNS IS
1074: SELECT 1
1075: FROM JAI_AR_SUP_LINES A,
1076: JAI_AR_SUP_HDRS_ALL B,
1077: RA_CUSTOMER_TRX_ALL C,
1078: RA_CUST_TRX_TYPES_ALL D,
1079: JAI_AR_SUP_TAXES E