APPS.PV_ORDER_MGMT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 163: from oe_order_headers_all

159: PROCEDURE set_mo_policy_context (p_order_header_id IN number)
160: IS
161: CURSOR c_order_header_id (l_order_header_id number) IS
162: select org_id
163: from oe_order_headers_all
164: where header_id = l_order_header_id;
165:
166: curr_org number;
167: order_org number;

Line 1822: FROM oe_order_headers_all oeoh, oe_order_Lines_all oeol,

1818:
1819: cursor c_get_payment_amount(cv_order_header_id_tbl JTF_NUMBER_TABLE) IS
1820: SELECT /*+ cardinality( T 10 ) */ ((oeol.unit_selling_price*oeol.ordered_quantity)+nvl(oeol.tax_value,0)) payment_amount, oeoh.transactional_curr_code currency,
1821: oeoh.header_id
1822: FROM oe_order_headers_all oeoh, oe_order_Lines_all oeol,
1823: (SELECT * FROM TABLE (CAST(cv_order_header_id_tbl AS JTF_NUMBER_TABLE))) T
1824: WHERE oeoh.header_id = T.column_value
1825: AND oeoh.header_id = oeol.header_id;
1826:

Line 2940: from oe_order_headers_all

2936: select payment_amount,
2937: transactional_curr_code
2938: into l_payment_amount,
2939: l_trans_currency
2940: from oe_order_headers_all
2941: where header_id = lx_enrl_info(i).order_header_id;
2942:
2943: select meaning
2944: into l_pmnt_mode_mean