DBA Data[Home] [Help]

APPS.PO_DISTRIBUTIONS_DRAFT_PVT dependencies on PO_DISTRIBUTIONS_ALL

Line 266: po_distributions_all pd

262: SELECT 'Y'
263: INTO l_clm_document
264: FROM po_headers_all h,
265: po_doc_style_headers pdsh,
266: po_distributions_all pd
267: WHERE h.style_id = pdsh.style_id
268: AND h.po_header_id = pd.po_header_id
269: AND pd.po_distribution_id = l_delete_list(1)
270: AND NVL(pdsh.clm_flag,'N') = 'Y'

Line 369: po_distributions_all PD

365: INTO l_id_list,
366: l_del_flag_list,
367: l_txn_exists_list
368: FROM po_distributions_draft_all PDD,
369: po_distributions_all PD
370: WHERE PDD.draft_id = p_draft_info.draft_id
371: AND NVL(PDD.change_accepted_flag, 'Y') = 'Y'
372: AND PDD.po_distribution_id = PD.po_distribution_id(+);
373: