APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 1546: from ra_customer_trx_all rct

1542: ,rctl.inventory_item_id inventory_item_id
1543: ,nvl(rct.sold_to_customer_id, rct.bill_to_customer_id) party_id
1544: ,jrct.organization_id organization_id
1545: ,jrct.location_id location_id
1546: from ra_customer_trx_all rct
1547: ,ra_customer_trx_lines_all rctl
1548: ,jai_ar_trxs jrct
1549: ,hz_parties hzp
1550: ,hz_cust_accounts hzca

Line 1990: FROM ra_customer_trx_all rct

1986: AND jrec.tax_type IN ('Service', 'SERVICE_EDUCATION_CESS', 'SERVICE_SH_EDU_CESS');
1987:
1988: CURSOR c_get_document_line_num( p_document_id number,p_document_line_id number) IS
1989: SELECT rctl.line_number
1990: FROM ra_customer_trx_all rct
1991: ,ra_customer_trx_lines_all rctl
1992: WHERE rct.customer_trx_id = p_document_id
1993: and rctl.customer_trx_id = rct.customer_trx_id
1994: and rctl.customer_trx_line_id = p_document_line_id;

Line 2006: ra_customer_trx_all rct

2002: -----------------------------------------------
2003: cursor get_pa_trx_date is
2004: SELECT rct.trx_date document_date
2005: FROM jai_trx_repo_extract_gt gt,
2006: ra_customer_trx_all rct
2007: WHERE gt.document_id = p_document_id
2008: AND gt.document_line_id = p_document_line_id
2009: AND gt.transaction_source = p_document_source
2010: AND gt.repository_invoice_id = rct.customer_trx_id;

Line 3337: lv_created_from ra_customer_trx_all.created_from%type ;

3333: , p_process_message out nocopy varchar2
3334: , p_process_flag out nocopy varchar2
3335: )
3336: is
3337: lv_created_from ra_customer_trx_all.created_from%type ;
3338:
3339: cursor c_chk_ar_inv_attr (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type
3340: ,cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
3341: )

Line 3339: cursor c_chk_ar_inv_attr (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type

3335: )
3336: is
3337: lv_created_from ra_customer_trx_all.created_from%type ;
3338:
3339: cursor c_chk_ar_inv_attr (cp_customer_trx_id ra_customer_trx_all.customer_trx_id%type
3340: ,cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type
3341: )
3342: is
3343: select rct.created_from

Line 3350: from ra_customer_trx_all rct, ra_customer_trx_lines_all rctl

3346: , rctl.interface_line_attribute6 -- holds order line id if context is ORDER_ENTRY
3347: , rctl.interface_line_attribute1 -- 5876390, 6012570, holds PROJECT_NUMBER if context is PROJECTS INVOICES
3348: , rctl.interface_line_attribute2 -- 5876390, 6012570, holds DRAFT_INVOICE_NUM if context is PROJECTS_INOVICES
3349: , rctl.global_attribute_category ----Added by zhiwei for Bug#12604133
3350: from ra_customer_trx_all rct, ra_customer_trx_lines_all rctl
3351: where rct.customer_trx_id = cp_customer_trx_id
3352: and rct.customer_trx_id = rctl.customer_trx_id
3353: and rctl.customer_trx_line_id = cp_customer_trx_line_id;
3354: