DBA Data[Home] [Help]

APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 1765: FROM ra_customer_trx_lines_all a,

1761: b.customer_trx_id,
1762: b.complete_flag,
1763: b.trx_date conv_date,
1764: a.customer_trx_line_id
1765: FROM ra_customer_trx_lines_all a,
1766: ra_customer_trx_all b
1767: WHERE a.inventory_item_id IN ( SELECT na.inventory_item_id
1768: FROM ozf_na_products_temp na)
1769: AND a.line_type = 'LINE'

Line 1996: FROM ra_customer_trx_lines_all

1992: SELECT inventory_item_id,
1993: quantity_credited,
1994: uom_code,
1995: org_id -- added for bug # 10379136
1996: FROM ra_customer_trx_lines_all
1997: WHERE customer_trx_line_id = p_cust_trx_line_id;
1998:
1999: CURSOR c_get_debit_memo_details(p_cust_trx_line_id NUMBER) IS
2000: SELECT inventory_item_id,

Line 2004: FROM ra_customer_trx_lines_all

2000: SELECT inventory_item_id,
2001: quantity_invoiced,
2002: uom_code,
2003: org_id -- added for bug # 10379136
2004: FROM ra_customer_trx_lines_all
2005: WHERE customer_trx_line_id = p_cust_trx_line_id;
2006:
2007:
2008: CURSOR c_get_util_amt(p_customer_trx_line_id NUMBER,