APPS.PO_CORE_S dependencies on PO_ACTION_HISTORY

Line 7002: l_offline_flag PO_ACTION_HISTORY.offline_code%TYPE;

6998: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
6999: l_closed_code PO_HEADERS.closed_code%TYPE;
7000: l_frozen_flag PO_HEADERS.frozen_flag%TYPE;
7001: l_user_hold_flag PO_HEADERS.user_hold_flag%TYPE;
7002: l_offline_flag PO_ACTION_HISTORY.offline_code%TYPE;
7003: l_reserved_flag VARCHAR2(1);
7004:
7005: l_display_reserved VARCHAR2(1);
7006:

Line 7044: FROM po_lookup_codes polc, po_action_history poah

7040: BEGIN
7041:
7042: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7043: INTO l_offline_status, l_offline_flag
7044: FROM po_lookup_codes polc, po_action_history poah
7045: WHERE polc.lookup_type = 'DOCUMENT STATE'
7046: AND polc.lookup_code = poah.offline_code
7047: AND poah.object_id = p_document_id
7048: AND poah.object_type_code = 'REQUISITION'

Line 7110: FROM po_lookup_codes polc, po_action_history poah

7106: BEGIN
7107:
7108: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7109: INTO l_offline_status, l_offline_flag
7110: FROM po_lookup_codes polc, po_action_history poah
7111: WHERE polc.lookup_type = 'DOCUMENT STATE'
7112: AND polc.lookup_code = poah.offline_code
7113: AND poah.object_id = p_document_id
7114: AND poah.object_type_code IN ('PO', 'PA')

Line 7176: FROM po_lookup_codes polc, po_action_history poah

7172: BEGIN
7173:
7174: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7175: INTO l_offline_status, l_offline_flag
7176: FROM po_lookup_codes polc, po_action_history poah
7177: WHERE polc.lookup_type = 'DOCUMENT STATE'
7178: AND polc.lookup_code = poah.offline_code
7179: AND poah.object_id = p_document_id
7180: AND poah.object_type_code = 'RELEASE'