DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1547: ,ra_customer_trx_lines_all rctl

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
1551: ,mtl_system_items msi

Line 1991: ,ra_customer_trx_lines_all rctl

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;
1995:

Line 1998: ln_document_line_num ra_customer_trx_lines_all.line_number%TYPE;

1994: and rctl.customer_trx_line_id = p_document_line_id;
1995:
1996: r_rcpt_trx_details c_get_rcpt_trx_details%ROWTYPE;
1997: r_rcpt_app_trx_details c_get_rcpt_app_trx_details%ROWTYPE;
1998: ln_document_line_num ra_customer_trx_lines_all.line_number%TYPE;
1999: /*Added by Wenqiong for Advanced Receipts End*/
2000:
2001: ----Added by Qiong for bug13597785 Begin
2002: -----------------------------------------------

Line 2192: ra_customer_trx_lines_all rla

2188:
2189: CURSOR get_ar_gl_date_cur IS
2190: SELECT rda.gl_date
2191: FROM ra_cust_trx_line_gl_dist_all rda,
2192: ra_customer_trx_lines_all rla
2193: WHERE rda.customer_trx_id = p_document_id
2194: AND rda.account_class = 'REV'
2195: AND rda.customer_trx_line_id = rla.customer_trx_line_id
2196: --Modified by Qinglei 27-Dec-2011 for bug#13531399

Line 3340: ,cp_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type

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
3344: , rct.interface_header_context

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:

Line 3611: ,ra_customer_trx_lines_all ractl

3607: is
3608: select recs.service_type_code
3609: from jai_rgm_trx_records recs
3610: ,jai_rgm_trx_refs refs
3611: ,ra_customer_trx_lines_all ractl
3612: where ractl.interface_line_attribute6 = p_document_line_id
3613: and ractl.interface_line_context = 'ORDER ENTRY'
3614: and ractl.line_type = 'LINE'
3615: and ractl.customer_trx_line_id = refs.item_line_id