DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 253: oe_order_headers_all ordhdr

249: SELECT ordhdr.order_number
250: ,ordhdr.invoice_to_org_id
251: ,pmt.trxn_extension_id
252: FROM
253: oe_order_headers_all ordhdr
254: ,oe_payments pmt
255: WHERE ordhdr.header_id = c_order_header_id
256: AND ordhdr.header_id = pmt.header_id
257: AND pmt.line_id IS NULL

Line 2333: FROM oe_order_headers_all

2329:
2330: CURSOR l_bookdt_csr (p_ord_hdrid NUMBER)
2331: IS
2332: SELECT booked_date, order_firmed_date
2333: FROM oe_order_headers_all
2334: WHERE header_id = p_ord_hdrid;
2335:
2336: --Territory changes
2337: CURSOR resource_details (p_resource_id NUMBER)

Line 16930: FROM oe_order_headers_all

16926:
16927: CURSOR get_order_number
16928: IS
16929: SELECT order_number
16930: FROM oe_order_headers_all
16931: WHERE header_id = p_order_id;
16932:
16933: CURSOR get_contract_number
16934: IS