DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_HEADERS_MERGE_V

Line 153: FROM po_headers_merge_v phm

149: SELECT nvl(phm.status, 'DRAFT'),
150: nvl(phm.closed_code, 'OPEN'),
151: nvl(phm.frozen_flag, 'N'),
152: nvl(phm.user_hold_flag, 'N')
153: FROM po_headers_merge_v phm
154: WHERE phm.po_header_id = docid
155: and phm.draft_id= draftId;
156:
157: CURSOR state_req(docid NUMBER) IS

Line 636: FROM po_headers_merge_v poh

632: IF p_draft_id IS NOT NULL AND p_draft_id <> -1 THEN
633: BEGIN
634: SELECT poh.agent_id
635: INTO x_preparer_id
636: FROM po_headers_merge_v poh
637: WHERE poh.po_header_id = p_document_id
638: AND poh.draft_id = p_draft_id;
639: EXCEPTION
640: WHEN OTHERS THEN

Line 1083: FROM PO_HEADERS_MERGE_V poh

1079: poh.revision_num
1080: INTO l_old_status,
1081: l_creation_date,
1082: l_revision_num
1083: FROM PO_HEADERS_MERGE_V poh
1084: WHERE poh.po_header_id = p_document_id
1085: AND poh.draft_id = p_draft_id;
1086:
1087: ELSE