POR_LINE_LOCATIONS_SUMMARY

Details

Schema: FUSION
Object owner: POR
Object type: VIEW

Columns

Name
REQUISITION_LINE_ID PO_HEADER_ID PO_LINE_ID LINE_NUM LINE_LOCATION_ID SHIPMENT_NUM QUANTITY PRICE_OVERRIDE AMOUNT NEED_BY_DATE PROMISED_DATE QUANTITY_SHIPPED QUANTITY_RECEIVED UNIT_OF_MEASURE QUANTITY_CANCELLED AMOUNT_CANCELLED VALUE_BASIS AMOUNT_BILLED QUANTITY_DELIVERED AMOUNT_DELIVERED CURRENCY_CODE

Name

REQUISITION_LINE_ID

PO_HEADER_ID

PO_LINE_ID

LINE_NUM

LINE_LOCATION_ID

SHIPMENT_NUM

QUANTITY

PRICE_OVERRIDE

AMOUNT

NEED_BY_DATE

PROMISED_DATE

QUANTITY_SHIPPED

QUANTITY_RECEIVED

UNIT_OF_MEASURE

QUANTITY_CANCELLED

AMOUNT_CANCELLED

VALUE_BASIS

AMOUNT_BILLED

QUANTITY_DELIVERED

AMOUNT_DELIVERED

CURRENCY_CODE

Query

SQL_Statement
SELECT MAX(PORLINES.REQUISITION_LINE_ID) REQUISITION_LINE_ID, MAX(POLINES.PO_HEADER_ID) PO_HEADER_ID, MAX(POLINES.PO_LINE_ID) PO_LINE_ID, MAX(POLINES.LINE_NUM) LINE_NUM, POLOCATS.LINE_LOCATION_ID LINE_LOCATION_ID, MAX(POLOCATS.SHIPMENT_NUM) SHIPMENT_NUM, MAX(POLOCATS.QUANTITY) QUANTITY, MAX(POLOCATS.PRICE_OVERRIDE) PRICE_OVERRIDE, MAX(POLOCATS.AMOUNT) AMOUNT, MAX(POLOCATS.NEED_BY_DATE) NEED_BY_DATE, MAX(POLOCATS.PROMISED_DATE) PROMISED_DATE, MAX(POLOCATS.QUANTITY_SHIPPED) QUANTITY_SHIPPED, MAX(POLOCATS.QUANTITY_RECEIVED) QUANTITY_RECEIVED, MAX(POUOM.UNIT_OF_MEASURE) UNIT_OF_MEASURE, MAX(POLOCATS.QUANTITY_CANCELLED) QUANTITY_CANCELLED, MAX(POLOCATS.AMOUNT_CANCELLED) AMOUNT_CANCELLED, MAX(POLOCATS.VALUE_BASIS) VALUE_BASIS, MAX(POLOCATS.AMOUNT_BILLED) AMOUNT_BILLED, SUM(PODISTS.QUANTITY_DELIVERED) QUANTITY_DELIVERED, SUM(PODISTS.AMOUNT_DELIVERED) AMOUNT_DELIVERED, MAX(POHEADER.CURRENCY_CODE) CURRENCY_CODE FROM POR_REQUISITION_LINES_ALL PORLINES, POR_REQ_DISTRIBUTIONS_ALL PORDISTS, PO_DISTRIBUTIONS_ALL PODISTS, PO_LINE_LOCATIONS_ALL POLOCATS, PO_LINES_ALL POLINES, PO_HEADERS_ALL POHEADER, INV_UNITS_OF_MEASURE_VL POUOM WHERE PORLINES.REQUISITION_LINE_ID = PORDISTS.REQUISITION_LINE_ID AND PORDISTS.DISTRIBUTION_ID = PODISTS.REQ_DISTRIBUTION_ID AND PODISTS.LINE_LOCATION_ID = POLOCATS.LINE_LOCATION_ID AND POLOCATS.PO_LINE_ID = POLINES.PO_LINE_ID AND POLINES.PO_HEADER_ID = POHEADER.PO_HEADER_ID AND POLOCATS.UOM_CODE = POUOM.UOM_CODE(+) AND PORLINES.LINE_GROUP = 'PO' GROUP BY POLOCATS.LINE_LOCATION_ID,PORLINES.REQUISITION_LINE_ID

SQL_Statement

SELECT

MAX(PORLINES.REQUISITION_LINE_ID) REQUISITION_LINE_ID,

MAX(POLINES.PO_HEADER_ID) PO_HEADER_ID,

MAX(POLINES.PO_LINE_ID) PO_LINE_ID,

MAX(POLINES.LINE_NUM) LINE_NUM,

POLOCATS.LINE_LOCATION_ID LINE_LOCATION_ID,

MAX(POLOCATS.SHIPMENT_NUM) SHIPMENT_NUM,

MAX(POLOCATS.QUANTITY) QUANTITY,

MAX(POLOCATS.PRICE_OVERRIDE) PRICE_OVERRIDE,

MAX(POLOCATS.AMOUNT) AMOUNT,

MAX(POLOCATS.NEED_BY_DATE) NEED_BY_DATE,

MAX(POLOCATS.PROMISED_DATE) PROMISED_DATE,

MAX(POLOCATS.QUANTITY_SHIPPED) QUANTITY_SHIPPED,

MAX(POLOCATS.QUANTITY_RECEIVED) QUANTITY_RECEIVED,

MAX(POUOM.UNIT_OF_MEASURE) UNIT_OF_MEASURE,

MAX(POLOCATS.QUANTITY_CANCELLED) QUANTITY_CANCELLED,

MAX(POLOCATS.AMOUNT_CANCELLED) AMOUNT_CANCELLED,

MAX(POLOCATS.VALUE_BASIS) VALUE_BASIS,

MAX(POLOCATS.AMOUNT_BILLED) AMOUNT_BILLED,

SUM(PODISTS.QUANTITY_DELIVERED) QUANTITY_DELIVERED,

SUM(PODISTS.AMOUNT_DELIVERED) AMOUNT_DELIVERED,

MAX(POHEADER.CURRENCY_CODE) CURRENCY_CODE

FROM

POR_REQUISITION_LINES_ALL PORLINES,

POR_REQ_DISTRIBUTIONS_ALL PORDISTS,

PO_DISTRIBUTIONS_ALL PODISTS,

PO_LINE_LOCATIONS_ALL POLOCATS,

PO_LINES_ALL POLINES,

PO_HEADERS_ALL POHEADER,

INV_UNITS_OF_MEASURE_VL POUOM

WHERE

PORLINES.REQUISITION_LINE_ID = PORDISTS.REQUISITION_LINE_ID AND

PORDISTS.DISTRIBUTION_ID = PODISTS.REQ_DISTRIBUTION_ID AND

PODISTS.LINE_LOCATION_ID = POLOCATS.LINE_LOCATION_ID AND

POLOCATS.PO_LINE_ID = POLINES.PO_LINE_ID AND

POLINES.PO_HEADER_ID = POHEADER.PO_HEADER_ID AND

POLOCATS.UOM_CODE = POUOM.UOM_CODE(+) AND

PORLINES.LINE_GROUP = 'PO'

GROUP BY POLOCATS.LINE_LOCATION_ID,PORLINES.REQUISITION_LINE_ID