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_TRX_LINES_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 74: FROM RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

70: lv_service_type_code VARCHAR2(30);
71:
72: CURSOR transaction_type_cur IS
73: SELECT a.type
74: FROM RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
75: WHERE a.cust_trx_type_id = b.cust_trx_type_id
76: AND b.customer_trx_id = v_header_id
77: AND NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
78:

Line 130: FROM RA_CUSTOMER_TRX_ALL

126: invoice_currency_code,
127: exchange_rate_type,
128: nvl(exchange_date, trx_date),
129: exchange_rate
130: FROM RA_CUSTOMER_TRX_ALL
131: WHERE customer_trx_id = v_header_id;
132:
133: CURSOR localization_header_info_cur IS
134: SELECT organization_id

Line 470: cursor c_gl_dist_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type) is

466: ld_gl_dist_date date;
467: v_service_type VARCHAR2(30);
468: v_num_check Number;
469:
470: cursor c_gl_dist_date(cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type) is
471: select gl_date
472: from ra_cust_trx_line_gl_dist_all
473: where customer_trx_id = cp_customer_trx_id
474: and account_class = jai_constants.account_class_rec

Line 517: FROM RA_CUSTOMER_TRX_ALL A

513: A.ship_to_customer_id,
514: NVL(A.ship_to_site_use_id, 0),
515: A.bill_to_customer_id,
516: NVL(A.bill_to_site_use_id, 0)
517: FROM RA_CUSTOMER_TRX_ALL A
518: WHERE customer_trx_id = v_header_id;
519:
520: Cursor header_info_cur IS
521: SELECT set_of_books_id,

Line 527: FROM RA_CUSTOMER_TRX_ALL

523: exchange_rate_type,
524: exchange_date,
525: exchange_rate,
526: trx_date
527: FROM RA_CUSTOMER_TRX_ALL
528: WHERE customer_trx_id = v_header_id;
529:
530: Cursor address_cur(p_ship_to_site_use_id IN Number) IS
531: SELECT cust_acct_site_id address_id

Line 547: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B

543: SELECT organization_id, location_id FROM JAI_AR_TRX_APPS_RELS_T;
544:
545: CURSOR organization_cur IS
546: SELECT A.organization_id, location_id
547: FROM JAI_AR_TRXS A, RA_CUSTOMER_TRX_ALL B
548: WHERE A.trx_number = B.recurred_from_trx_number
549: AND B.customer_trx_id = v_header_id;
550:
551: CURSOR CREATED_FROM_CUR IS

Line 553: FROM ra_customer_trx_all

549: AND B.customer_trx_id = v_header_id;
550:
551: CURSOR CREATED_FROM_CUR IS
552: SELECT created_from, trx_date
553: FROM ra_customer_trx_all
554: WHERE customer_trx_id = v_header_id;
555:
556: ld_trx_date ra_customer_trx_all.trx_Date%type;
557:

Line 556: ld_trx_date ra_customer_trx_all.trx_Date%type;

552: SELECT created_from, trx_date
553: FROM ra_customer_trx_all
554: WHERE customer_trx_id = v_header_id;
555:
556: ld_trx_date ra_customer_trx_all.trx_Date%type;
557:
558: CURSOR ONCE_COMPLETE_FLAG_CUR IS
559: SELECT once_completed_flag
560: FROM JAI_AR_TRXS

Line 565: FROM RA_CUSTOMER_TRX_ALL

561: WHERE customer_trx_id = v_header_id;
562:
563: CURSOR ROW_ID_CUR IS
564: SELECT rowid
565: FROM RA_CUSTOMER_TRX_ALL
566: WHERE customer_trx_id = v_header_id;
567:
568: CURSOR old_line_amount_cur IS
569: SELECT line_amount

Line 581: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

577: WHERE CUSTOMER_TRX_LINE_ID = v_customer_trx_line_id;
578:
579: Cursor transaction_type_cur IS
580: Select a.type
581: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
582: Where a.cust_trx_type_id = b.cust_trx_type_id
583: And b.customer_trx_id = v_header_id
584: And NVL(a.org_id, 0) = NVL(pr_new.org_id, 0);
585:

Line 1118: FROM RA_CUSTOMER_TRX_ALL A

1114: v_trans_type Varchar2(30);
1115:
1116: Cursor bind_cur IS
1117: SELECT A.org_id, A.bill_to_customer_id, NVL(A.bill_to_site_use_id, 0)
1118: FROM RA_CUSTOMER_TRX_ALL A
1119: WHERE customer_trx_id = v_header_id;
1120:
1121: Cursor header_info_cur IS
1122: SELECT set_of_books_id,

Line 1128: FROM RA_CUSTOMER_TRX_ALL

1124: exchange_rate_type,
1125: exchange_date,
1126: exchange_rate,
1127: trx_date
1128: FROM RA_CUSTOMER_TRX_ALL
1129: WHERE customer_trx_id = v_header_id;
1130:
1131: CURSOR excise_cal_cur IS
1132: select A.tax_id, A.tax_rate, A.tax_amount tax_amt, b.tax_type t_type

Line 1146: FROM RA_CUSTOMER_TRX_ALL

1142: SELECT organization_id
1143: FROM JAI_AR_TRXS
1144: WHERE trx_number =
1145: (SELECT recurred_from_trx_number
1146: FROM RA_CUSTOMER_TRX_ALL
1147: WHERE customer_trx_id = v_header_id);
1148:
1149: CURSOR CREATED_FROM_CUR IS
1150: SELECT created_from

Line 1151: FROM ra_customer_trx_all

1147: WHERE customer_trx_id = v_header_id);
1148:
1149: CURSOR CREATED_FROM_CUR IS
1150: SELECT created_from
1151: FROM ra_customer_trx_all
1152: WHERE customer_trx_id = v_header_id;
1153:
1154: Cursor transaction_type_cur IS
1155: Select a.type

Line 1156: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1152: WHERE customer_trx_id = v_header_id;
1153:
1154: Cursor transaction_type_cur IS
1155: Select a.type
1156: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1157: Where a.cust_trx_type_id = b.cust_trx_type_id
1158: And b.customer_trx_id = v_header_id
1159: And (a.org_id = pr_new.org_id OR
1160: (a.org_id is null and pr_new.org_id is null));

Line 1455: FROM RA_CUSTOMER_TRX_ALL A

1451: v_last_update_login Number;
1452:
1453: Cursor bind_cur IS
1454: SELECT A.org_id, A.bill_to_customer_id, NVL(A.bill_to_site_use_id, 0)
1455: FROM RA_CUSTOMER_TRX_ALL A
1456: WHERE customer_trx_id = v_header_id;
1457:
1458: Cursor header_info_cur IS
1459: SELECT set_of_books_id,

Line 1465: FROM RA_CUSTOMER_TRX_ALL

1461: exchange_rate_type,
1462: exchange_date,
1463: exchange_rate,
1464: trx_date
1465: FROM RA_CUSTOMER_TRX_ALL
1466: WHERE customer_trx_id = v_header_id;
1467:
1468: Cursor tax_id_cur(p_tax_category_id IN Number) IS
1469: SELECT line_no

Line 1494: FROM RA_CUSTOMER_TRX_ALL

1490: SELECT organization_id, location_id
1491: FROM JAI_AR_TRXS
1492: WHERE trx_number =
1493: (SELECT recurred_from_trx_number
1494: FROM RA_CUSTOMER_TRX_ALL
1495: WHERE customer_trx_id = v_header_id);
1496:
1497: CURSOR CREATED_FROM_CUR IS
1498: SELECT created_from, trx_date

Line 1499: FROM ra_customer_trx_all

1495: WHERE customer_trx_id = v_header_id);
1496:
1497: CURSOR CREATED_FROM_CUR IS
1498: SELECT created_from, trx_date
1499: FROM ra_customer_trx_all
1500: WHERE customer_trx_id = v_header_id;
1501:
1502: CURSOR ONCE_COMPLETE_FLAG_CUR IS
1503: SELECT once_completed_flag

Line 1509: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b

1505: WHERE customer_trx_id = v_header_id;
1506:
1507: Cursor transaction_type_cur IS
1508: Select a.type
1509: From RA_CUST_TRX_TYPES_ALL a, RA_CUSTOMER_TRX_ALL b
1510: Where a.cust_trx_type_id = b.cust_trx_type_id
1511: And b.customer_trx_id = v_header_id
1512: And (a.org_id = pr_new.org_id OR
1513: (a.org_id is NULL AND pr_new.org_id is NULL));