APPS.PO_DATATEMPLATE_PKG dependencies on PO_DISTRIBUTIONS_MERGE_V

Line 1010: FROM po_distributions_merge_v pod,

1006:
1007: SELECT XMLAgg(XMLElement("REF_PR_NUM", segment1))
1008: INTO l_req_nums
1009: FROM (SELECT distinct h.segment1
1010: FROM po_distributions_merge_v pod,
1011: po_req_distributions_all prd,
1012: po_requisition_headers_all h,
1013: po_requisition_lines_all l
1014: WHERE pod.po_header_id = p_header_id

Line 1048: FROM po_distributions_merge_v pod

1044: BEGIN
1045: SELECT XMLAgg(XMLElement("ACRN", acrn))
1046: INTO l_acrns
1047: FROM (SELECT distinct pod.acrn
1048: FROM po_distributions_merge_v pod
1049: WHERE pod.po_header_id = p_header_id
1050: and pod.po_line_id = p_line_id
1051: and pod.draft_id = p_draft_id);
1052: