APPS.PV_ORDER_MGMT_PVT dependencies on OE_ORDER_LINES_ALL

Line 275: from oe_order_lines_all,(SELECT * FROM TABLE (CAST(cv_order_header_id AS JTF_NUMBER_TABLE))) t

271:
272: CURSOR validate_price (cv_order_header_id JTF_NUMBER_TABLE) IS
273: select 1 from dual where exists
274: (select /*+ CARDINALITY(t 10) */ 1
275: from oe_order_lines_all,(SELECT * FROM TABLE (CAST(cv_order_header_id AS JTF_NUMBER_TABLE))) t
276: where header_id = t.column_value
277: and (unit_list_price is null or
278: unit_selling_price is null or price_list_id is null));
279:

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: