APPS.POA_EDW_PO_DIST_F_C dependencies on PO_DISTRIBUTIONS_ALL

Line 566: po_distributions_all pod

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
570: and pll.shipment_type = 'STANDARD'

Line 582: po_distributions_all pod

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
585: and pod.po_line_id = pol.po_line_id
586: and pod.po_header_id = poh.po_header_id

Line 678: po_distributions_all pod,

674: NVL(poh.currency_code,
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')