eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on RA_CUST_TRX_TYPES_ALL

Line 132: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

128: v_trans_type Varchar2(30);
129:
130: /*Cursor transaction_type_cur IS
131: Select a.type
132: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
133: Where a.cust_trx_type_id = b.cust_trx_type_id
134: And b.customer_trx_id = v_customer_trx_id
135: And NVL(a.org_id,0) = NVL(pr_old.org_id,0);
136: */

Line 142: From RA_CUST_TRX_TYPES_ALL a

138: -- the above cursor commented and using the following instead.
139:
140: Cursor transaction_type_cur IS
141: Select a.type
142: From RA_CUST_TRX_TYPES_ALL a
143: Where cust_trx_type_id
144: in
145: (
146: SELECT cust_trx_type_id

Line 349: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

345:
346:
347: Cursor transaction_type_cur IS
348: Select a.type
349: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
350: Where a.cust_trx_type_id = b.cust_trx_type_id
351: And b.customer_trx_id = v_header_id
352: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
353:

Line 878: ra_cust_trx_types_all c

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

Line 891: ra_cust_trx_types_all e

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

Line 910: ra_cust_trx_types_all D

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

Line 977: ra_cust_trx_types_all D,

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

Line 1002: ra_cust_trx_types_all e,

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
1004: WHERE pr_new.customer_trx_id = D.customer_trx_id
1005: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
1006: AND c.customer_trx_id = b.customer_trx_id

Line 1051: RA_CUST_TRX_TYPES_ALL D

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

Line 1078: RA_CUST_TRX_TYPES_ALL D,

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

Line 1097: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

1093: v_trans_type VARCHAR2(30);
1094:
1095: CURSOR transaction_type_cur IS
1096: SELECT A.TYPE
1097: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
1098: WHERE A.cust_trx_type_id = b.cust_trx_type_id
1099: AND b.customer_trx_id = v_header_id
1100: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
1101: /* Code Added For Service Module */

Line 4640: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4636:
4637: v_trans_type VARCHAR2(30);
4638: CURSOR transaction_type_cur IS
4639: SELECT A.TYPE
4640: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4641: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4642: AND b.customer_trx_id = v_header_id
4643: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4644:

Line 6018: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6014: v_trans_type VARCHAR2(30);
6015:
6016: CURSOR transaction_type_cur IS
6017: SELECT A.TYPE
6018: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6019: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6020: AND b.customer_trx_id = v_header_id
6021: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
6022:

Line 6413: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

6409:
6410:
6411: Cursor transaction_type_cur IS
6412: Select a.type
6413: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
6414: Where a.cust_trx_type_id = b.cust_trx_type_id
6415: And b.customer_trx_id = v_header_id
6416: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
6417:

Line 7092: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

7088:
7089:
7090: Cursor transaction_type_cur IS
7091: Select a.type
7092: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
7093: Where a.cust_trx_type_id = b.cust_trx_type_id
7094: And b.customer_trx_id = v_header_id
7095: And (a.org_id = pr_new.org_id
7096: OR

Line 7431: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

7427:
7428:
7429: Cursor transaction_type_cur IS
7430: Select a.type
7431: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
7432: Where a.cust_trx_type_id = b.cust_trx_type_id
7433: And b.customer_trx_id = v_header_id
7434: And ( a.org_id = pr_new.org_id
7435: OR

Line 7845: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

7841: -- 6369471
7842: -- cursor to get transaction type
7843: CURSOR c_transaction_type IS
7844: SELECT A.TYPE
7845: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
7846: WHERE A.cust_trx_type_id = b.cust_trx_type_id
7847: AND b.customer_trx_id = r_new.customer_trx_id
7848: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
7849: