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 113: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

109: v_trans_type Varchar2(30);
110:
111: /*Cursor transaction_type_cur IS
112: Select a.type
113: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
114: Where a.cust_trx_type_id = b.cust_trx_type_id
115: And b.customer_trx_id = v_customer_trx_id
116: And NVL(a.org_id,0) = NVL(pr_old.org_id,0);
117: */

Line 123: From RA_CUST_TRX_TYPES_ALL a

119: -- the above cursor commented and using the following instead.
120:
121: Cursor transaction_type_cur IS
122: Select a.type
123: From RA_CUST_TRX_TYPES_ALL a
124: Where cust_trx_type_id
125: in
126: (
127: SELECT cust_trx_type_id

Line 323: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

319:
320:
321: Cursor transaction_type_cur IS
322: Select a.type
323: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
324: Where a.cust_trx_type_id = b.cust_trx_type_id
325: And b.customer_trx_id = v_header_id
326: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
327:

Line 812: ra_cust_trx_types_all c

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

Line 825: ra_cust_trx_types_all e

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

Line 842: ra_cust_trx_types_all D

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

Line 909: ra_cust_trx_types_all D,

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

Line 934: ra_cust_trx_types_all e,

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
936: WHERE pr_new.customer_trx_id = D.customer_trx_id
937: AND D.trx_number = TO_CHAR(c.SUPPLEMENTARY_NUM)
938: AND c.customer_trx_id = b.customer_trx_id

Line 983: RA_CUST_TRX_TYPES_ALL D

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

Line 1010: RA_CUST_TRX_TYPES_ALL D,

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

Line 1029: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

1025: v_trans_type VARCHAR2(30);
1026:
1027: CURSOR transaction_type_cur IS
1028: SELECT A.TYPE
1029: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
1030: WHERE A.cust_trx_type_id = b.cust_trx_type_id
1031: AND b.customer_trx_id = v_header_id
1032: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
1033: /* Code Added For Service Module */

Line 4309: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

4305:
4306: v_trans_type VARCHAR2(30);
4307: CURSOR transaction_type_cur IS
4308: SELECT A.TYPE
4309: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
4310: WHERE A.cust_trx_type_id = b.cust_trx_type_id
4311: AND b.customer_trx_id = v_header_id
4312: AND NVL(A.org_id,0) = NVL(pr_new.org_id,0);
4313:

Line 5033: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5029:
5030:
5031: Cursor transaction_type_cur IS
5032: Select a.type
5033: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5034: Where a.cust_trx_type_id = b.cust_trx_type_id
5035: And b.customer_trx_id = v_header_id
5036: And NVL(a.org_id,0) = NVL(pr_new.org_id,0);
5037:

Line 5636: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5632:
5633:
5634: Cursor transaction_type_cur IS
5635: Select a.type
5636: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5637: Where a.cust_trx_type_id = b.cust_trx_type_id
5638: And b.customer_trx_id = v_header_id
5639: And (a.org_id = pr_new.org_id
5640: OR

Line 5973: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

5969:
5970:
5971: Cursor transaction_type_cur IS
5972: Select a.type
5973: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
5974: Where a.cust_trx_type_id = b.cust_trx_type_id
5975: And b.customer_trx_id = v_header_id
5976: And ( a.org_id = pr_new.org_id
5977: OR

Line 6348: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b

6344: -- 6369471
6345: -- cursor to get transaction type
6346: CURSOR c_transaction_type IS
6347: SELECT A.TYPE
6348: FROM RA_CUST_TRX_TYPES_ALL A, RA_CUSTOMER_TRX_ALL b
6349: WHERE A.cust_trx_type_id = b.cust_trx_type_id
6350: AND b.customer_trx_id = r_new.customer_trx_id
6351: AND NVL(A.org_id,0) = NVL(r_new.org_id,0);
6352: