DBA Data[Home] [Help]

APPS.PO_PAR_REQ_CREATE_UTIL dependencies on PO_DRAFTS

Line 82: po_drafts POD

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
86: AND POD.draft_id = POH.draft_id;

Line 230: po_drafts POD,

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,
234: po_header_id,

Line 456: po_drafts pod,

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
460: AND PHD.po_header_id = p_po_header_id