APPS.OE_HEADER_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 5384: FROM OE_ORDER_HEADERS_ALL

5380: , x_header_rec.customer_signature
5381: , x_header_rec.customer_signature_date
5382: --key Transaction Dates
5383: , x_header_rec.order_firmed_date
5384: FROM OE_ORDER_HEADERS_ALL
5385: WHERE HEADER_ID = p_header_id;
5386: /* AND
5387: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
5388: ;*/

Line 5494: FROM OE_ORDER_HEADERS_ALL

5490: END IF;
5491:
5492: SELECT header_id, lock_control
5493: INTO l_header_id, l_db_lock_control
5494: FROM OE_ORDER_HEADERS_ALL
5495: WHERE HEADER_ID = l_header_id
5496: FOR UPDATE NOWAIT;
5497:
5498: -- { Start of the fix 2436046, query part is old

Line 7656: FROM oe_order_headers_all

7652:
7653: BEGIN
7654: SELECT order_number,order_type_id
7655: INTO l_order_number,l_order_type_id
7656: FROM oe_order_headers_all
7657: WHERE header_id = p_header_id;
7658:
7659: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7660: x_order_number := l_order_number;

Line 7963: From OE_ORDER_HEADERS_ALL

7959: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7960:
7961: Select Count(Header_id) into
7962: lcount
7963: From OE_ORDER_HEADERS_ALL
7964: WHERE order_type_id = p_x_header_rec.order_type_id
7965: and order_number = p_x_header_rec.order_number
7966: -- We need to remove the check condition around the version number.
7967: --Bug #3357896.

Line 7998: From OE_ORDER_HEADERS_ALL

7994: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7995:
7996: Select Count(Header_id) into
7997: lcount
7998: From OE_ORDER_HEADERS_ALL
7999: WHERE order_type_id = p_x_header_rec.order_type_id
8000: and quote_number = p_x_header_rec.quote_number
8001: -- We need to remove the check condition around the version number.
8002: --Bug #3357896.

Line 9438: FROM OE_ORDER_HEADERS_ALL

9434: --satisfied.
9435: BEGIN
9436: SELECT PAYMENT_TERM_ID,TRANSACTIONAL_CURR_CODE
9437: INTO l_payment_term_id,l_currency_code
9438: FROM OE_ORDER_HEADERS_ALL
9439: WHERE HEADER_ID = p_x_header_rec.header_id;
9440: EXCEPTION
9441: WHEN NO_DATA_FOUND THEN
9442: l_payment_term_id := NULL;

Line 9607: from oe_order_headers_all

9603: oe_debug_pub.add('Entering OR_HEADER_UTIL.Validate_Gapless_Seq',1);
9604:
9605: select order_type_id into
9606: l_order_type_id
9607: from oe_order_headers_all
9608: where header_id = l_header_id;
9609:
9610: ltype := Get_ord_seq_type(l_order_type_id,l_transaction_phase_code);
9611:

Line 9970: FROM OE_ORDER_HEADERS_ALL

9966: SELECT order_source_id, orig_sys_document_ref, change_sequence,
9967: source_document_type_id, source_document_id
9968: INTO l_order_source_id, l_orig_sys_document_ref, l_change_sequence,
9969: l_source_document_type_id, l_source_document_id
9970: FROM OE_ORDER_HEADERS_ALL
9971: WHERE header_id = p_x_header_rec.header_Id;
9972: EXCEPTION
9973: WHEN NO_DATA_FOUND THEN
9974: l_order_source_id := null;

Line 10012: FROM OE_ORDER_HEADERS_ALL

10008:
10009: BEGIN
10010: SELECT NVL(SOLD_TO_ORG_ID,p_x_header_rec.sold_to_org_id)
10011: INTO p_x_header_rec.sold_to_org_id
10012: FROM OE_ORDER_HEADERS_ALL
10013: WHERE HEADER_ID = p_x_header_rec.header_id;
10014: EXCEPTION
10015: WHEN OTHERS THEN
10016: NULL;