APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 887: ,ra_customer_trx_lines_all rctl

883: ,nvl(rct.sold_to_customer_id, rct.bill_to_customer_id) party_id
884: ,jrct.organization_id organization_id
885: ,jrct.location_id location_id
886: from ra_customer_trx_all rct
887: ,ra_customer_trx_lines_all rctl
888: ,jai_ar_trxs jrct
889: ,hz_parties hzp
890: ,hz_cust_accounts hzca
891: ,mtl_system_items msi

Line 1924: ,cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

1920: is
1921: lv_created_from ra_customer_trx_all.created_from%type ;
1922:
1923: cursor c_chk_ar_inv_attr (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type
1924: ,cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
1925: )
1926: is
1927: select rct.created_from
1928: , rct.interface_header_context

Line 1933: from ra_customer_trx_all rct, ra_customer_trx_lines_all rctl

1929: , rct.interface_header_attribute1 -- holds order number if context is ORDER_ENTRY
1930: , rctl.interface_line_attribute6 -- holds order line id if context is ORDER_ENTRY
1931: , rctl.interface_line_attribute1 -- 5876390, 6012570, holds PROJECT_NUMBER if context is PROJECTS INVOICES
1932: , rctl.interface_line_attribute2 -- 5876390, 6012570, holds DRAFT_INVOICE_NUM if context is PROJECTS_INOVICES
1933: from ra_customer_trx_all rct, ra_customer_trx_lines_all rctl
1934: where rct.customer_trx_id = cp_customer_trx_id
1935: and rct.customer_trx_id = rctl.customer_trx_id
1936: and rctl.customer_trx_line_id = cp_customer_trx_line_id;
1937:

Line 2205: ,ra_customer_trx_lines_all ractl

2201: is
2202: select recs.service_type_code
2203: from jai_rgm_trx_records recs
2204: ,jai_rgm_trx_refs refs
2205: ,ra_customer_trx_lines_all ractl
2206: where ractl.interface_line_attribute6 = p_document_line_id
2207: and ractl.interface_line_context = 'ORDER ENTRY'
2208: and ractl.line_type = 'LINE'
2209: and ractl.customer_trx_line_id = refs.item_line_id