DBA Data[Home] [Help]

APPS.OKS_EXTWARPRGM_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 293: oe_order_headers_all ordhdr

289: SELECT ordhdr.order_number
290: ,ordhdr.invoice_to_org_id
291: ,pmt.trxn_extension_id
292: FROM
293: oe_order_headers_all ordhdr
294: ,oe_payments pmt
295: WHERE ordhdr.header_id = c_order_header_id
296: AND ordhdr.header_id = pmt.header_id
297: AND pmt.line_id IS NULL

Line 2382: FROM oe_order_headers_all

2378:
2379: CURSOR l_bookdt_csr (p_ord_hdrid NUMBER)
2380: IS
2381: SELECT booked_date, order_firmed_date
2382: FROM oe_order_headers_all
2383: WHERE header_id = p_ord_hdrid;
2384:
2385: --Territory changes
2386: CURSOR resource_details (p_resource_id NUMBER)

Line 17228: FROM oe_order_headers_all

17224:
17225: CURSOR get_order_number
17226: IS
17227: SELECT order_number
17228: FROM oe_order_headers_all
17229: WHERE header_id = p_order_id;
17230:
17231: CURSOR get_contract_number
17232: IS