[Home] [Help]
1005: FND_CURRENCIES CURR,
1006: FND_DOCUMENT_SEQUENCES SEQ,
1007: AR_SYSTEM_PARAMETERS AR,
1008: RA_BATCH_SOURCES BS,
1009: RA_CUST_TRX_TYPES TYPES,
1010: HZ_CUST_ACCOUNTS BILL_CUST,
1011: HZ_PARTIES BILL_PARTY,
1012: HZ_CUST_ACCT_SITES BILL_AS,
1013: HZ_CUST_SITE_USES BILL_SU,
1013: HZ_CUST_SITE_USES BILL_SU,
1014: HZ_PARTY_SITES BILL_PS,
1015: HZ_LOCATIONS BILL_LOC,
1016: RA_CUSTOMER_TRX INV,
1017: RA_CUST_TRX_TYPES INV_TT,
1018: RA_CUSTOMER_TRX_LINES INV_L,
1019: HR_ALL_ORGANIZATION_UNITS HR,
1020: HR_ORGANIZATION_UNITS HRL,
1021: RA_CUSTOMER_TRX REL_T,
1018: RA_CUSTOMER_TRX_LINES INV_L,
1019: HR_ALL_ORGANIZATION_UNITS HR,
1020: HR_ORGANIZATION_UNITS HRL,
1021: RA_CUSTOMER_TRX REL_T,
1022: RA_CUST_TRX_TYPES REL_TT,
1023: AR_MEMO_LINES_B ML
1024: WHERE
1025: TRX.customer_trx_id = p_customer_trx_id and
1026: TRX.customer_trx_id = LINES.customer_trx_id and
2518: FND_CURRENCIES CURR,
2519: FND_DOCUMENT_SEQUENCES SEQ,
2520: AR_SYSTEM_PARAMETERS AR,
2521: RA_BATCH_SOURCES BS,
2522: RA_CUST_TRX_TYPES TYPES,
2523: HZ_CUST_ACCOUNTS BILL_CUST,
2524: HZ_PARTIES BILL_PARTY,
2525: HZ_CUST_ACCT_SITES BILL_AS,
2526: HZ_CUST_SITE_USES BILL_SU,
3204: l_hold_codes_tbl ZX_API_PUB.hold_codes_tbl_type;
3205: l_error_count NUMBER;
3206: l_trx_number RA_CUSTOMER_TRX.trx_number%type;
3207: l_msg VARCHAR2(2000);
3208: l_ttype ra_cust_trx_types_all.type%type;
3209: l_line_count NUMBER;
3210:
3211: CURSOR c_errors IS
3212: select trx_id, trx_line_id, message_name, message_text
3245: l_trx_number,
3246: l_ttype, -- 7668830
3247: l_line_count
3248: from ra_customer_trx t,
3249: ra_cust_trx_types tt,
3250: ra_customer_trx_lines ctl
3251: where t.customer_trx_id = p_customer_trx_id
3252: and t.cust_trx_type_id = tt.cust_trx_type_id
3253: and t.org_id = tt.org_id