APPS.OE_SYNC_ORDER_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 516: FROM oe_order_headers_all ohdr,

512: ,ohdr.ordered_date
513: ,ohdr.org_id
514: ,ohdr.order_source_id
515: ,ohld.released_flag
516: FROM oe_order_headers_all ohdr,
517: oe_order_holds_all ohld,
518: oe_order_sources osrc -- to remove hardcoding on order_source_id
519: WHERE ohdr.header_id = ohld.header_id
520: -- AND ohdr.order_source_id = 28

Line 534: oe_order_headers_all h,

530: CURSOR get_ord_hld_cur IS
531: SELECT ooh.header_id
532: ,ooh.line_id
533: FROM oe_order_holds ooh,
534: oe_order_headers_all h,
535: oe_order_sources osrc -- to remove hardcoding on order_source_id
536: WHERE h.header_id = ooh.header_id
537: -- AND h.order_source_id = 28
538: AND h.order_source_id = osrc.order_source_id

Line 1070: oe_order_headers_all hdr -- Bug 10009062 Fix

1066: ack.REQUEST_ID ,ack.ACKNOWLEDGMENT_TYPE ,ack.FLOW_STATUS_CODE,
1067: ack.INVOICE_ADDRESS_ID, ack.PRICE_LIST_ID,
1068: ack.TRANSACTIONAL_CURR_CODE --Bug 9182921
1069: FROM oe_header_acks ack,
1070: oe_order_headers_all hdr -- Bug 10009062 Fix
1071: WHERE ack.request_id = p_hdr_req_id
1072: AND hdr.header_id = ack.header_id;
1073:
1074: -- Cursor modified for Enh. 7244277, 7644412, 7644426