DBA Data[Home] [Help]

APPS.POA_EDW_PO_DIST_F_C dependencies on PO_HEADERS_ALL

Line 565: po_headers_all poh,

561: FROM
562: (SELECT pod.PO_DISTRIBUTION_ID, pol.item_id, pod.creation_date
563: FROM po_lines_all pol,
564: po_line_locations_all pll,
565: po_headers_all poh,
566: po_distributions_all pod
567: WHERE pod.line_location_id = pll.line_location_id
568: and pod.po_line_id = pol.po_line_id
569: and pod.po_header_id = poh.po_header_id

Line 580: po_headers_all poh,

576: UNION ALL
577: SELECT pod.PO_DISTRIBUTION_ID, pol.item_id, pod.creation_date
578: FROM po_lines_all pol,
579: po_line_locations_all pll,
580: po_headers_all poh,
581: po_releases_all por,
582: po_distributions_all pod
583: WHERE pod.line_location_id = pll.line_location_id
584: and pod.po_release_id = por.po_release_id

Line 679: po_headers_all poh,

675: gsob.currency_code)) From_Currency,
676: fstg.Collection_Status
677: FROM POA_EDW_PO_DIST_FSTG fstg,
678: po_distributions_all pod,
679: po_headers_all poh,
680: gl_sets_of_books gsob
681: WHERE (fstg.COLLECTION_STATUS = 'RATE NOT AVAILABLE' OR
682: fstg.COLLECTION_STATUS = 'INVALID CURRENCY')
683: AND fstg.DESTRIBUTION_ID = pod.po_distribution_id