DBA Data[Home] [Help]

APPS.PO_CLOSEOUT_PVT dependencies on PO_VENDORS

Line 175: FROM po_vendors pv

171:
172: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
173: SELECT pv.vendor_name
174: INTO l_vendor_name
175: FROM po_vendors pv
176: WHERE pv.vendor_id = l_vendor_id;
177:
178: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_vendor_name ' || l_vendor_name);
179: l_progress := 60;

Line 1533: FROM po_vendors pv

1529: l_progress := 60;
1530:
1531: SELECT pv.vendor_name
1532: INTO l_vendor_name
1533: FROM po_vendors pv
1534: WHERE pv.vendor_id = l_vendor_id;
1535:
1536: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_vendor_name ' || l_vendor_name);
1537: l_progress := 65;

Line 2246: po_vendors pv

2242: FROM po_headers ph,
2243: po_doc_style_headers pdsh,
2244: po_lookup_codes plc1,
2245: po_lookup_codes plc2,
2246: po_vendors pv
2247: WHERE clm_award_administrator = l_admin_id
2248: AND authorization_status = 'APPROVED'
2249: AND Nvl(clm_closeout_status, 'OPEN') = 'OPEN'
2250: AND ph.style_id = pdsh.style_id

Line 3778: PO_VENDORS VO

3774: l_buyer_id,
3775: l_admin_id
3776:
3777: FROM PO_HEADERS_ALL PHA,
3778: PO_VENDORS VO
3779: WHERE PHA.po_header_id = l_document_id
3780: AND PHA.vendor_id = VO.vendor_id;
3781:
3782: l_doc_type_disp:= PO_DOC_STYLE_PVT.get_style_display_name(l_document_id);