DBA Data[Home] [Help]

APPS.OE_ERROR_WF dependencies on OE_BLANKET_HEADERS_ALL

Line 92: from oe_blanket_headers_all

88: SELECT order_number, order_type_id, order_category_code,
89: org_id, VERSION_NUMBER, FLOW_STATUS_CODE
90: into l_order_number, l_order_type_id, l_order_category_code,
91: l_org_id, l_version_number, l_flow_status_code
92: from oe_blanket_headers_all
93: where header_id = err_itemkey;
94:
95: SELECT T.NAME
96: INTO l_order_type_name

Line 1697: FROM OE_BLANKET_HEADERS_ALL

1693:
1694: ELSIF p_item_type = 'OEBH' THEN
1695:
1696: SELECT header_id into l_hdr_id
1697: FROM OE_BLANKET_HEADERS_ALL
1698: WHERE header_id = to_number(p_item_key)
1699: FOR UPDATE NOWAIT;
1700:
1701: END IF;