APPS.PON_CLM_CLO_UTIL_PKG dependencies on PO_LINES_DRAFT_ALL

Line 1648: po_lines_draft_all pol,

1644: FROM po_requisition_lines_all prl,
1645: po_requisition_headers_all prh,
1646: po_req_distributions_all prd,
1647: po_headers_draft_all poh,
1648: po_lines_draft_all pol,
1649: po_distributions_draft_all pod,
1650: po_drafts pd
1651:
1652: WHERE

Line 1665: FROM po_lines_draft_all

1661: AND pod.req_distribution_id = prd.distribution_id
1662: AND Nvl(pol.delete_flag,'N') = 'Y'
1663: AND (pol.group_line_id IS NOT NULL
1664: AND NOT EXISTS (SELECT 'Parent Clin Deleted'
1665: FROM po_lines_draft_all
1666: WHERE po_header_id=pol.po_header_id
1667: AND draft_id=pol.draft_id
1668: AND Nvl(delete_flag,'N')='Y'
1669: AND po_line_id=pol.group_line_id ))

Line 1691: po_lines_draft_all pol,

1687: poh.agent_id
1688: FROM po_requisition_lines_all prl,
1689: po_requisition_headers_all prh,
1690: po_headers_draft_all poh,
1691: po_lines_draft_all pol,
1692: po_drafts pd
1693:
1694: WHERE
1695: Nvl(pol.draft_id,-1)=Nvl(poh.draft_id,-1)

Line 1706: FROM po_lines_draft_all

1702: AND (Nvl(pol.clm_info_flag,'N')='Y'
1703: OR Nvl(pol.clm_option_indicator,'B')='O')
1704: AND ((pol.group_line_id IS NOT NULL
1705: AND NOT EXISTS (SELECT 'Parent Clin Deleted'
1706: FROM po_lines_draft_all
1707: WHERE po_header_id=pol.po_header_id
1708: AND draft_id=pol.draft_id
1709: AND Nvl(delete_flag,'N')='Y'
1710: AND po_line_id=pol.group_line_id ))

Line 1713: FROM po_lines_draft_all

1709: AND Nvl(delete_flag,'N')='Y'
1710: AND po_line_id=pol.group_line_id ))
1711: OR (pol.clm_base_line_num IS NOT NULL
1712: AND NOT EXISTS ( SELECT 'Base Line Deleted'
1713: FROM po_lines_draft_all
1714: WHERE po_header_id=pol.po_header_id
1715: AND draft_id=pol.draft_id
1716: AND Nvl(delete_flag,'N')='Y'
1717: AND po_line_id=pol.clm_base_line_num ))