APPS.OE_HEADER_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 5234: FROM OE_ORDER_HEADERS_ALL

5230: , x_header_rec.customer_signature
5231: , x_header_rec.customer_signature_date
5232: --key Transaction Dates
5233: , x_header_rec.order_firmed_date
5234: FROM OE_ORDER_HEADERS_ALL
5235: WHERE HEADER_ID = p_header_id;
5236: /* AND
5237: (NVL(ORG_ID,NVL(l_org_id,0))= NVL(l_org_id,0))
5238: ;*/

Line 5344: FROM OE_ORDER_HEADERS_ALL

5340: END IF;
5341:
5342: SELECT header_id, lock_control
5343: INTO l_header_id, l_db_lock_control
5344: FROM OE_ORDER_HEADERS_ALL
5345: WHERE HEADER_ID = l_header_id
5346: FOR UPDATE NOWAIT;
5347:
5348: -- { Start of the fix 2436046, query part is old

Line 7504: FROM oe_order_headers_all

7500:
7501: BEGIN
7502: SELECT order_number,order_type_id
7503: INTO l_order_number,l_order_type_id
7504: FROM oe_order_headers_all
7505: WHERE header_id = p_header_id;
7506:
7507: x_order_source := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
7508: x_order_number := l_order_number;

Line 7811: From OE_ORDER_HEADERS_ALL

7807: IF nvl(p_x_header_rec.transaction_phase_code,'F') = 'F' THEN
7808:
7809: Select Count(Header_id) into
7810: lcount
7811: From OE_ORDER_HEADERS_ALL
7812: WHERE order_type_id = p_x_header_rec.order_type_id
7813: and order_number = p_x_header_rec.order_number
7814: -- We need to remove the check condition around the version number.
7815: --Bug #3357896.

Line 7846: From OE_ORDER_HEADERS_ALL

7842: ELSIF p_x_header_rec.transaction_phase_code = 'N' THEN
7843:
7844: Select Count(Header_id) into
7845: lcount
7846: From OE_ORDER_HEADERS_ALL
7847: WHERE order_type_id = p_x_header_rec.order_type_id
7848: and quote_number = p_x_header_rec.quote_number
7849: -- We need to remove the check condition around the version number.
7850: --Bug #3357896.

Line 9220: FROM OE_ORDER_HEADERS_ALL

9216: --satisfied.
9217: BEGIN
9218: SELECT PAYMENT_TERM_ID,TRANSACTIONAL_CURR_CODE
9219: INTO l_payment_term_id,l_currency_code
9220: FROM OE_ORDER_HEADERS_ALL
9221: WHERE HEADER_ID = p_x_header_rec.header_id;
9222: EXCEPTION
9223: WHEN NO_DATA_FOUND THEN
9224: l_payment_term_id := NULL;

Line 9389: from oe_order_headers_all

9385: oe_debug_pub.add('Entering OR_HEADER_UTIL.Validate_Gapless_Seq',1);
9386:
9387: select order_type_id into
9388: l_order_type_id
9389: from oe_order_headers_all
9390: where header_id = l_header_id;
9391:
9392: ltype := Get_ord_seq_type(l_order_type_id,l_transaction_phase_code);
9393: