DBA Data[Home] [Help]

APPS.ARP_XLA_EVENTS dependencies on RA_CUSTOMER_TRX

Line 20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE

16: bld_dml_flag DBMS_SQL.VARCHAR2_TABLE,--insert,update,delete
17: bld_temp_event_id DBMS_SQL.VARCHAR2_TABLE
18: );
19:
20: TYPE line_tbl_type IS TABLE OF ra_customer_trx_lines.customer_trx_line_id%TYPE
21: INDEX BY BINARY_INTEGER;
22:
23: /*-----------------------------------------------------------------------+
24: | Default bulk fetch size, and starting index |

Line 653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

649: ct.legal_entity_id LEGAL_ENTITY_ID ' || CRLF;
650:
651: l_from_clause :=
652: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
653: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
654: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd1, ' || CRLF ||
655: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd ' || CRLF;
656:
657: --note that the ctlgd1 fragment can be made dynamic for batch processes

Line 829: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

825: ct.legal_entity_id LEGAL_ENTITY_ID' || CRLF;
826:
827: l_from_clause :=
828: ' FROM ra_cust_trx_types' || l_all_clause || ' tty, ' || CRLF ||
829: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
830: ' ar_adjustments' || l_all_clause || ' adj ' || CRLF;
831:
832: ----------------------------------------------------------------------------------
833: --A script to denormalize the BR_ADJUSTMENT_ID on adjustment table may be written

Line 1609: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;

1605:
1606: l_from_clause :=
1607: ' FROM ar_receivable_applications' || l_all_clause || ' app, ' ||
1608: ' ra_cust_trx_line_gl_dist' || l_all_clause || ' ctlgd, ' ||
1609: ' ra_customer_trx' || l_all_clause || ' ct ' || CRLF ;
1610:
1611: l_where_clause :=
1612: ' WHERE app.application_type = ''CM''
1613: AND app.status IN (''APP'',''ACTIVITY'') --HYU

Line 1789: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

1785:
1786: l_from_clause :=
1787: ' FROM ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1788: ' ar_transaction_history' || l_all_clause || ' trh1, ' || CRLF ||
1789: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1790: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1791:
1792: l_where_clause := ' where ct.customer_trx_id = trh.customer_trx_id ' || CRLF ||
1793: ' and ct.cust_trx_type_id = tty.cust_trx_type_id ' || CRLF ||

Line 1877: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||

1873: l_from_clause :=
1874: ' FROM xla_events' || ' ev1, ' || CRLF ||
1875: ' xla_transaction_entities_upg' || ' evn, ' || CRLF ||
1876: ' ar_transaction_history' || l_all_clause || ' trh, ' || CRLF ||
1877: ' ra_customer_trx' || l_all_clause || ' ct, ' || CRLF ||
1878: ' ra_cust_trx_types' || l_all_clause || ' tty ' || CRLF;
1879:
1880: l_where_clause :=
1881: ' WHERE ct.customer_trx_id = trh.customer_trx_id ' || CRLF ||

Line 2254: prev_trx_id ra_customer_trx.customer_trx_id%TYPE;

2250: l_change_matrix VARCHAR2(30);
2251:
2252: temp_event_id BINARY_INTEGER := 0;
2253:
2254: prev_trx_id ra_customer_trx.customer_trx_id%TYPE;
2255:
2256: l_type VARCHAR2(30);
2257: l_build_ctr BINARY_INTEGER;
2258: l_ev_type VARCHAR2(20);

Line 2481: ra_customer_trx_all trx

2477: and ae2.event_id IN
2478: ( select MAX( ae.event_id )
2479: from xla_events ae,
2480: xla_transaction_entities_upg xt,
2481: ra_customer_trx_all trx
2482: where trx.customer_trx_id = ev_rec.trx_id(i)
2483: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2484: and xt.entity_code = 'TRANSACTIONS'
2485: and xt.ledger_id = trx.set_of_books_id

Line 2515: ra_customer_trx_all trx

2511: and ae2.event_id IN
2512: ( select MAX( ae.event_id )
2513: from xla_events ae,
2514: xla_transaction_entities_upg xt,
2515: ra_customer_trx_all trx
2516: where trx.customer_trx_id = ev_rec.trx_id(i)
2517: and NVL(xt.source_id_int_1,-99) = trx.customer_trx_id
2518: and xt.entity_code = 'BILLS_RECEIVABLE'
2519: and xt.ledger_id = trx.set_of_books_id

Line 3468: FROM ra_customer_trx_lines ctl

3464: IS
3465:
3466: CURSOR cu_is_rev_rec_run IS
3467: SELECT 'Y'
3468: FROM ra_customer_trx_lines ctl
3469: WHERE ctl.customer_trx_id = p_invoice_id
3470: AND ctl.line_type = 'LINE'
3471: AND NVL(ctl.autorule_complete_flag,'Y') <> 'N';
3472:

Line 4283: ra_customer_trx ct,

4279:
4280: /*7229913 */
4281: CURSOR c_ct_rules is
4282: select xe.event_id event_id from
4283: ra_customer_trx ct,
4284: xla_transaction_entities_upg xte,
4285: xla_events xe
4286: where ct.customer_trx_id = p_document_id
4287: and ct.invoicing_rule_id in (-2,-3)

Line 4330: select invoicing_rule_id into l_invoicing_rule_id from ra_customer_trx

4326: FETCH c_ct INTO l_event_id;
4327: CLOSE c_ct;
4328:
4329: /*7229913*/
4330: select invoicing_rule_id into l_invoicing_rule_id from ra_customer_trx
4331: where customer_trx_id = p_document_id;
4332:
4333: IF l_invoicing_rule_id in (-2,-3) then
4334: OPEN c_ct_rules ;