PO_XCC_DISTRIBUTIONS

Details

Schema: FUSION
Object owner: PO
Object type: VIEW

Columns

Name
PO_HEADER_ID PO_VERSION_ID PO_DISTRIBUTION_ID PO_LINE_ID PO_LINE_LOCATION_ID DATA_SET_ID SLA_PO_VERSION_ID EVENT_ID BUDGET_DATE FUNDS_STATUS

Name

PO_HEADER_ID

PO_VERSION_ID

PO_DISTRIBUTION_ID

PO_LINE_ID

PO_LINE_LOCATION_ID

DATA_SET_ID

SLA_PO_VERSION_ID

EVENT_ID

BUDGET_DATE

FUNDS_STATUS

Query

SQL_Statement
SELECT bc.PO_HEADER_ID, DECODE(bc.BC_EVENT, 'REOPEN_PO', bc.DATA_SET_ID, 'CF_REOPEN_PO', bc.DATA_SET_ID, bc.PO_VERSION_ID) po_version_id, bc.PO_DISTRIBUTION_ID, bc.PO_LINE_ID, bc.PO_LINE_LOCATION_ID, bc.DATA_SET_ID, bc.PO_VERSION_ID sla_po_version_id, bc.EVENT_ID, bc.BUDGET_DATE, bc.FUNDS_STATUS FROM PO_BCEA_DATA bc, PO_VERSIONS v WHERE bc.PO_VERSION_ID = v.VERSION_ID AND v.CHANGE_ORDER_STATUS = 'PROCESSED' AND v.CO_CANCELED_FLAG != 'Y' AND (bc.FUNDS_STATUS IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_NO_CONTROL_BUD', 'RESERVED_NOT_APPLICABLE') OR (bc.FUNDS_STATUS = 'NOT_ATTEMPTED' AND EVENT_ID IS NOT NULL)) AND nvl(bc.reservation_backout_flag,'N') != 'Y' AND bc.BC_EVENT NOT IN ('FINALLY_CLOSE_PO', 'CF_FINALLY_CLOSE_PO') AND bc.CREATION_DATE = (SELECT MAX(bc1.CREATION_DATE) FROM PO_BCEA_DATA bc1, PO_VERSIONS v1 WHERE bc1.PO_VERSION_ID = v1.VERSION_ID AND v1.CHANGE_ORDER_STATUS = 'PROCESSED' AND v1.CO_CANCELED_FLAG != 'Y' AND bc1.PO_DISTRIBUTION_ID = bc.PO_DISTRIBUTION_ID AND nvl(bc1.reservation_backout_flag,'N') != 'Y' AND (bc1.FUNDS_STATUS IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_NO_CONTROL_BUD', 'RESERVED_NOT_APPLICABLE') OR (bc1.FUNDS_STATUS = 'NOT_ATTEMPTED' AND EVENT_ID IS NOT NULL)) AND bc1.BC_EVENT NOT IN ('FINALLY_CLOSE_PO', 'CF_FINALLY_CLOSE_PO'))

SQL_Statement

SELECT

bc.PO_HEADER_ID,

DECODE(bc.BC_EVENT, 'REOPEN_PO', bc.DATA_SET_ID, 'CF_REOPEN_PO', bc.DATA_SET_ID, bc.PO_VERSION_ID) po_version_id,

bc.PO_DISTRIBUTION_ID,

bc.PO_LINE_ID,

bc.PO_LINE_LOCATION_ID,

bc.DATA_SET_ID,

bc.PO_VERSION_ID sla_po_version_id,

bc.EVENT_ID,

bc.BUDGET_DATE,

bc.FUNDS_STATUS

FROM

PO_BCEA_DATA bc,

PO_VERSIONS v

WHERE

bc.PO_VERSION_ID = v.VERSION_ID AND v.CHANGE_ORDER_STATUS = 'PROCESSED' AND v.CO_CANCELED_FLAG != 'Y' AND (bc.FUNDS_STATUS IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_NO_CONTROL_BUD', 'RESERVED_NOT_APPLICABLE') OR (bc.FUNDS_STATUS = 'NOT_ATTEMPTED' AND EVENT_ID IS NOT NULL)) AND nvl(bc.reservation_backout_flag,'N') != 'Y' AND bc.BC_EVENT NOT IN ('FINALLY_CLOSE_PO', 'CF_FINALLY_CLOSE_PO') AND bc.CREATION_DATE = (SELECT

MAX(bc1.CREATION_DATE)

FROM

PO_BCEA_DATA bc1,

PO_VERSIONS v1

WHERE

bc1.PO_VERSION_ID = v1.VERSION_ID AND v1.CHANGE_ORDER_STATUS = 'PROCESSED' AND v1.CO_CANCELED_FLAG != 'Y' AND bc1.PO_DISTRIBUTION_ID = bc.PO_DISTRIBUTION_ID AND nvl(bc1.reservation_backout_flag,'N') != 'Y' AND (bc1.FUNDS_STATUS IN ('RESERVED_PASSED', 'RESERVED_WARNING', 'RESERVED_NO_CONTROL_BUD', 'RESERVED_NOT_APPLICABLE') OR (bc1.FUNDS_STATUS = 'NOT_ATTEMPTED' AND EVENT_ID IS NOT NULL)) AND bc1.BC_EVENT NOT IN ('FINALLY_CLOSE_PO', 'CF_FINALLY_CLOSE_PO'))