APPS.PO_SGD_PKG dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 1738: FROM po_distributions_merge_v pod,

1734:
1735: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1736: INTO l_req_nums
1737: FROM (SELECT distinct h.segment1
1738: FROM po_distributions_merge_v pod,
1739: po_req_distributions_all prd,
1740: po_requisition_headers_all h,
1741: po_requisition_lines_all l
1742: WHERE pod.po_header_id = p_header_id

Line 1776: FROM po_distributions_merge_v pod

1772: BEGIN
1773: SELECT XMLAgg(XMLElement("ACRN", acrn))
1774: INTO l_acrns
1775: FROM (SELECT distinct pod.acrn
1776: FROM po_distributions_merge_v pod
1777: WHERE pod.po_header_id = p_header_id
1778: and pod.po_line_id = p_line_id
1779: and pod.draft_id = p_draft_id);
1780: