APPS.PO_CORE_S dependencies on PO_ACTION_HISTORY

Line 7210: l_offline_flag PO_ACTION_HISTORY.offline_code%TYPE;

7206: l_cancel_flag PO_HEADERS.cancel_flag%TYPE;
7207: l_closed_code PO_HEADERS.closed_code%TYPE;
7208: l_frozen_flag PO_HEADERS.frozen_flag%TYPE;
7209: l_user_hold_flag PO_HEADERS.user_hold_flag%TYPE;
7210: l_offline_flag PO_ACTION_HISTORY.offline_code%TYPE;
7211: l_reserved_flag VARCHAR2(1);
7212:
7213: l_display_reserved VARCHAR2(1);
7214:

Line 7252: FROM po_lookup_codes polc, po_action_history poah

7248: BEGIN
7249:
7250: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7251: INTO l_offline_status, l_offline_flag
7252: FROM po_lookup_codes polc, po_action_history poah
7253: WHERE polc.lookup_type = 'DOCUMENT STATE'
7254: AND polc.lookup_code = poah.offline_code
7255: AND poah.object_id = p_document_id
7256: AND poah.object_type_code = 'REQUISITION'

Line 7318: FROM po_lookup_codes polc, po_action_history poah

7314: BEGIN
7315:
7316: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7317: INTO l_offline_status, l_offline_flag
7318: FROM po_lookup_codes polc, po_action_history poah
7319: WHERE polc.lookup_type = 'DOCUMENT STATE'
7320: AND polc.lookup_code = poah.offline_code
7321: AND poah.object_id = p_document_id
7322: AND poah.object_type_code IN ('PO', 'PA')

Line 7384: FROM po_lookup_codes polc, po_action_history poah

7380: BEGIN
7381:
7382: SELECT polc.displayed_field, nvl(poah.offline_code, 'N')
7383: INTO l_offline_status, l_offline_flag
7384: FROM po_lookup_codes polc, po_action_history poah
7385: WHERE polc.lookup_type = 'DOCUMENT STATE'
7386: AND polc.lookup_code = poah.offline_code
7387: AND poah.object_id = p_document_id
7388: AND poah.object_type_code = 'RELEASE'