APPS.OZF_ACCRUAL_ENGINE dependencies on OE_ORDER_HEADERS_ALL

Line 1816: FROM oe_order_headers_all

1812: /* -- 6/3/2002 mpande changed as per PM specifications --
1813: We should accrue to the bill to org but not o the sold to org
1814: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1815: SELECT sold_to_org_id
1816: FROM oe_order_headers_all
1817: WHERE header_id = p_header_id;
1818: */
1819: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1820: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id

Line 1824: oe_order_headers_all header

1820: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1821: FROM hz_cust_acct_sites_all acct_site,
1822: hz_cust_site_uses_all site_use,
1823: hz_cust_accounts cust,
1824: oe_order_headers_all header
1825: WHERE header.header_id = p_header_id
1826: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
1827: AND acct_site.cust_account_id = cust.cust_account_id
1828: AND site_use.site_use_id = header.invoice_to_org_id ;

Line 1832: SELECT org_id FROM oe_order_headers_all

1828: AND site_use.site_use_id = header.invoice_to_org_id ;
1829:
1830: -- Cursor to get the org_id for order
1831: CURSOR c_org_id (p_order_header_id IN NUMBER)IS
1832: SELECT org_id FROM oe_order_headers_all
1833: WHERE header_id = p_order_header_id;
1834:
1835: BEGIN
1836: SAVEPOINT create_fund_utilization_acr;

Line 2000: oe_order_headers_all header

1996: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1997: FROM hz_cust_acct_sites_all acct_site,
1998: hz_cust_site_uses_all site_use,
1999: hz_cust_accounts cust,
2000: oe_order_headers_all header
2001: WHERE header.header_id = p_header_id
2002: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2003: AND acct_site.cust_account_id = cust.cust_account_id
2004: AND site_use.site_use_id = header.invoice_to_org_id ;

Line 2009: FROM oe_order_lines_all line, oe_order_headers_all header

2005:
2006: --Added for bug 7030415, get order's org_id
2007: CURSOR c_order_org_id (p_line_id IN NUMBER) IS
2008: SELECT header.org_id
2009: FROM oe_order_lines_all line, oe_order_headers_all header
2010: WHERE line_id = p_line_id
2011: AND line.header_id = header.header_id;
2012:
2013: CURSOR c_offer_type (p_offer_id IN NUMBER) IS

Line 2357: FROM oe_order_lines_all line, oe_order_headers_all header

2353: line.cancelled_quantity,
2354: line.line_category_code,
2355: header.transactional_curr_code,
2356: header.org_id
2357: FROM oe_order_lines_all line, oe_order_headers_all header
2358: WHERE line_id = p_line_id
2359: AND line.header_id = header.header_id;
2360:
2361: CURSOR c_list_line_info (p_list_line_id IN NUMBER) IS

Line 2988: FROM oe_order_headers_all

2984: booked_flag,
2985: transactional_curr_code,
2986: order_number,
2987: org_id
2988: FROM oe_order_headers_all
2989: WHERE header_id = p_header_id;
2990:
2991: CURSOR c_all_price_adjustments (p_line_id IN NUMBER) IS
2992: SELECT price_adjustment_id,

Line 3134: FROM oe_order_lines_all line, oe_order_headers_all header

3130: DECODE(line.line_category_code,'ORDER',NVL(line.shipped_quantity,0),
3131: 'RETURN', line.invoiced_quantity,
3132: line.ordered_quantity) shipped_quantity
3133:
3134: FROM oe_order_lines_all line, oe_order_headers_all header
3135: WHERE line.line_id = p_order_line_id
3136: AND line.header_id = header.header_id;
3137:
3138:

Line 5085: FROM oe_order_headers_all

5081:
5082: -- added for 3917556
5083: CURSOR c_get_offer_info (p_header_id IN NUMBER) IS
5084: SELECT order_number
5085: FROM oe_order_headers_all
5086: WHERE header_id = p_header_id;
5087:
5088: BEGIN
5089: x_retcode := 0;