APPS.OE_ERROR_WF dependencies on OE_ORDER_HEADERS_ALL

Line 490: from oe_order_headers_all

486: SELECT order_number, order_type_id, order_category_code,
487: org_id, SALESREP_ID, VERSION_NUMBER, FLOW_STATUS_CODE
488: into l_order_number, l_order_type_id, l_order_category_code,
489: l_org_id, l_salesrep_id, l_version_number, l_flow_status_code
490: from oe_order_headers_all
491: where header_id = err_itemkey;
492:
493: SELECT T.NAME
494: INTO l_order_type_name

Line 593: from oe_order_headers_all

589: SELECT order_number, order_type_id, order_category_code,
590: org_id, SALESREP_ID, VERSION_NUMBER
591: into l_order_number, l_order_type_id, l_order_category_code,
592: l_org_id, l_salesrep_id, l_version_number
593: from oe_order_headers_all
594: where header_id = l_header_id;
595:
596: SELECT T.NAME
597: INTO l_order_type_name

Line 740: from oe_order_headers_all

736: SELECT order_number, order_type_id, order_category_code,
737: SALESREP_ID, VERSION_NUMBER, FLOW_STATUS_CODE
738: into l_order_number, l_order_type_id, l_order_category_code,
739: l_salesrep_id, l_version_number, l_flow_status_code
740: from oe_order_headers_all
741: where header_id = l_header_id;
742:
743: BEGIN
744: SELECT T.NAME

Line 1108: From oe_order_headers_all

1104:
1105: Begin
1106: Select header_id
1107: Into x_header_id
1108: From oe_order_headers_all
1109: Where orig_sys_document_ref = x_orig_sys_document_ref
1110: And decode(l_customer_key_profile, 'Y',
1111: nvl(sold_to_org_id, -999), 1)
1112: = decode(l_customer_key_profile, 'Y',

Line 1678: FROM OE_ORDER_HEADERS_ALL

1674:
1675: IF p_item_type in ('OEOH','OENH') THEN
1676:
1677: SELECT ORDER_NUMBER into l_ord_num
1678: FROM OE_ORDER_HEADERS_ALL
1679: WHERE header_id = to_number(p_item_key)
1680: FOR UPDATE NOWAIT;
1681:
1682: ELSIF p_item_type = 'OEOL' THEN

Line 1690: FROM OE_ORDER_HEADERS_ALL

1686: WHERE line_id = to_number(p_item_key)
1687: FOR UPDATE NOWAIT;
1688:
1689: SELECT order_number into l_ord_num
1690: FROM OE_ORDER_HEADERS_ALL
1691: WHERE header_id = l_hdr_id
1692: FOR UPDATE NOWAIT;
1693:
1694: ELSIF p_item_type = 'OEBH' THEN

Line 2482: from oe_order_headers_all

2478:
2479: if p_item_key is not null then
2480:
2481: SELECT order_number into l_order_num
2482: from oe_order_headers_all
2483: where header_id = p_item_key;
2484:
2485: end if;
2486: