APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_HEADERS_DRAFT_ALL

Line 40: FROM po_headers_draft_all

36: SELECT vendor_id,
37: vendor_site_id,
38: vendor_contact_id
39: INTO l_vendor_id, l_vendor_site_id, l_vendor_contact_id
40: FROM po_headers_draft_all
41: WHERE po_header_id = p_po_header_id
42: AND draft_id = p_par_draft_id;
43:
44:

Line 81: FROM po_headers_draft_all POH,

77: POH.last_updated_by,
78: POH.last_update_login,
79: SYSDATE CREATION_DATE,
80: POH.created_by
81: FROM po_headers_draft_all POH,
82: po_drafts POD
83: WHERE POH.draft_id = p_par_draft_id
84: AND POH.po_header_id = p_po_header_id
85: AND POD.document_id = POH.po_header_id

Line 229: po_headers_draft_all POH,

225: l_vendor_site_id,
226: l_vendor_contact_id
227:
228: FROM po_lines_draft_all PLD,
229: po_headers_draft_all POH,
230: po_drafts POD,
231: po_line_types_b plt,
232: (SELECT po_line_id,
233: draft_id,

Line 455: FROM po_headers_draft_all PHD,

451: l_vendor_id,
452: l_vendor_site_id,
453: l_vendor_contact_id
454:
455: FROM po_headers_draft_all PHD,
456: po_drafts pod,
457: po_line_types_b PLT
458: WHERE PLT.line_type_id = 1
459: AND PHD.draft_id = p_par_draft_id