APPS.OE_CONTRACTS_UTIL dependencies on OE_ORDER_HEADERS_ALL

Line 205: FROM oe_order_headers_all

201:
202: ELSIF p_doc_type = OE_CONTRACTS_UTIL.G_SO_DOC_TYPE THEN
203: SELECT version_number
204: INTO l_latest_version_number
205: FROM oe_order_headers_all
206: WHERE header_id = p_copy_from_doc_id;
207:
208: END IF;
209: oe_debug_pub.add('l_latest_version_number for p_doc_type: '||p_doc_type || ' and p_copy_from_doc_id: '

Line 1183: FROM oe_order_headers_all

1179:
1180: --cursor to get the version number of the sales order
1181: CURSOR c_get_so_version (cp_header_id NUMBER) IS
1182: SELECT version_number
1183: FROM oe_order_headers_all
1184: WHERE header_id = cp_header_id;
1185: *********/
1186:
1187:

Line 1928: FROM oe_order_headers_all oh

1924: oh.shipping_method_code,
1925: oh.payment_term_id,
1926: oh.invoicing_rule_id,
1927: oh.org_id
1928: FROM oe_order_headers_all oh
1929:
1930: WHERE oh.header_id = p_doc_id;
1931:
1932:

Line 3337: FROM oe_order_headers_all a

3333:
3334: CURSOR find_ord_signed IS
3335: SELECT a.customer_signature,
3336: a.customer_signature_date
3337: FROM oe_order_headers_all a
3338: WHERE a.header_id = p_doc_id;
3339:
3340: BEGIN
3341: IF (l_debug_level > 0) THEN

Line 3351: oe_debug_pub.add('Fetching customer_signature and customer_signature_date from oe_order_headers_all ', 3);

3347: END IF;
3348: -- Initialize API return status to success
3349: x_return_status := FND_API.G_RET_STS_SUCCESS;
3350: IF l_debug_level > 0 THEN
3351: oe_debug_pub.add('Fetching customer_signature and customer_signature_date from oe_order_headers_all ', 3);
3352: oe_debug_pub.add('p_api_version: ' || p_api_version,3);
3353: oe_debug_pub.add('p_init_msg_list: ' || p_init_msg_list,3);
3354: oe_debug_pub.add('p_doc_id: ' || p_doc_id, 3);
3355: END IF;

Line 3479: FROM oe_order_headers_all

3475: IF p_target_doc_type = 'O' THEN
3476: BEGIN
3477: SELECT order_number
3478: INTO l_document_number
3479: FROM oe_order_headers_all
3480: WHERE header_id = p_target_doc_id;
3481: EXCEPTION
3482: WHEN NO_DATA_FOUND THEN
3483: l_document_number := NULL;

Line 4250: FROM oe_order_headers_all

4246: END IF;
4247: --Get the org_id
4248: BEGIN
4249: SELECT org_id into l_org_id
4250: FROM oe_order_headers_all
4251: WHERE header_id=p_doc_id;
4252: EXCEPTION
4253: when others then
4254: l_org_id:=NULL;