VIEW: PO.PO_DISTRIBUTIONS_ALL_EBS#

Source

View Text - Preformatted

select PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID, LINE_LOCATION_ID LINE_LOCATION_ID, PO_LINE_ID PO_LINE_ID, PO_HEADER_ID PO_HEADER_ID, PO_RELEASE_ID PO_RELEASE_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, QUANTITY_ORDERED QUANTITY_ORDERED, QUANTITY_BILLED QUANTITY_BILLED, QUANTITY_CANCELLED QUANTITY_CANCELLED, DISTRIBUTION_NUM DISTRIBUTION_NUM, RATE RATE, RATE_DATE RATE_DATE, ORG_ID ORG_ID, EURO_PO_DISTRIBUTION_ID EURO_PO_DISTRIBUTION_ID, EURO_LINE_LOCATION_ID EURO_LINE_LOCATION_ID, EURO_PO_LINE_ID EURO_PO_LINE_ID, EURO_PO_RELEASE_ID EURO_PO_RELEASE_ID, EURO_PO_HEADER_ID EURO_PO_HEADER_ID, QUANTITY_DELIVERED QUANTITY_DELIVERED, AMOUNT_BILLED AMOUNT_BILLED, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID, EURO_SOURCE_DISTRIBUTION_ID EURO_SOURCE_DISTRIBUTION_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID from "PO"."PO_DISTRIBUTIONS_ALL_EBS"

View Text - HTML Formatted

SELECT PO_DISTRIBUTION_ID PO_DISTRIBUTION_ID
, LINE_LOCATION_ID LINE_LOCATION_ID
, PO_LINE_ID PO_LINE_ID
, PO_HEADER_ID PO_HEADER_ID
, PO_RELEASE_ID PO_RELEASE_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, QUANTITY_ORDERED QUANTITY_ORDERED
, QUANTITY_BILLED QUANTITY_BILLED
, QUANTITY_CANCELLED QUANTITY_CANCELLED
, DISTRIBUTION_NUM DISTRIBUTION_NUM
, RATE RATE
, RATE_DATE RATE_DATE
, ORG_ID ORG_ID
, EURO_PO_DISTRIBUTION_ID EURO_PO_DISTRIBUTION_ID
, EURO_LINE_LOCATION_ID EURO_LINE_LOCATION_ID
, EURO_PO_LINE_ID EURO_PO_LINE_ID
, EURO_PO_RELEASE_ID EURO_PO_RELEASE_ID
, EURO_PO_HEADER_ID EURO_PO_HEADER_ID
, QUANTITY_DELIVERED QUANTITY_DELIVERED
, AMOUNT_BILLED AMOUNT_BILLED
, SOURCE_DISTRIBUTION_ID SOURCE_DISTRIBUTION_ID
, EURO_SOURCE_DISTRIBUTION_ID EURO_SOURCE_DISTRIBUTION_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM "PO"."PO_DISTRIBUTIONS_ALL_EBS"