DBA Data[Home] [Help]

APPS.PO_DATATEMPLATE_PKG dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1011: po_req_distributions_all prd,

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
1015: and pod.po_line_id = p_line_id