1. Tables and Views for SCM
  2. VCS_PREVIOUS_CYCLE_ENTRY_V

VCS_PREVIOUS_CYCLE_ENTRY_V

Details

  • Schema: FUSION

  • Object owner: VCS

  • Object type: VIEW

Columns

Name

PREVIOUS_BUCKET_ID

INVENTORY_ITEM_ID

ENTRY_CURRENT_FLAG

PREVIOUS_ENTRY_DETAIL_ID

PREVIOUS_QUANTITY

PREVIOUS_RESPONSE_QUANTITY

PREVIOUS_RESPONSE_QUANTITY_UOM

CURRENTENTRYID

PREVIOUSENTRYID

PREVIOUS_PRIMARY_UOM_CODE

SHIP_TO_ID

INVENTORY_ITEM_ORG_ID

PUBLISHED_DATE

COMMIT_DATE

ENTRY_LAST_UPDATE_DATE

LAST_UPDATED_BY

ENTRY_LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER_ENT

SHIP_FROM_ID

ORCH_CORRELATION_CODE

Query

SQL_Statement

SELECT

PreviousCycleDetailsEO.bucket_id AS PREVIOUS_BUCKET_ID,

CurrentCycleEntriesEO.INVENTORY_ITEM_ID ,

CurrentCycleEntriesEO.IS_CURRENT_FLAG AS ENTRY_CURRENT_FLAG,

PreviousCycleDetailsEO.entry_detail_id previous_entry_detail_id,

PreviousCycleDetailsEO.QUANTITY AS PREVIOUS_QUANTITY,

PreviousCycleDetailsEO.RESPONSE_QUANTITY AS PREVIOUS_RESPONSE_QUANTITY,

PreviousCycleDetailsEO.RESPONSE_QUANTITY_UOM AS PREVIOUS_RESPONSE_QUANTITY_UOM,

CurrentCycleEntriesEO.entry_id as CurrentEntryID,

PreviousCycleEntriesEO.entry_id as PreviousEntryID,

PreviousCycleEntriesEO.primary_uom_code AS PREVIOUS_PRIMARY_UOM_CODE,

CurrentCycleEntriesEO.SHIP_TO_ID,

CurrentCycleEntriesEO.INVENTORY_ITEM_ORG_ID,

CurrentCycleEntriesEO.PUBLISHED_DATE,

CurrentCycleEntriesEO.COMMIT_DATE,

CurrentCycleEntriesEO.LAST_UPDATE_DATE as ENTRY_LAST_UPDATE_DATE,

CurrentCycleEntriesEO.LAST_UPDATED_BY,

CurrentCycleEntriesEO.LAST_UPDATE_LOGIN AS ENTRY_LAST_UPDATE_LOGIN,

CurrentCycleEntriesEO.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER_ENT,

CurrentCycleEntriesEO.SHIP_FROM_ID,

CurrentCycleEntriesEO.ORCH_CORRELATION_CODE

FROM

VCS_COLLAB_ENT CurrentCycleEntriesEO

LEFT JOIN VCS_COLLAB_ENT PreviousCycleEntriesEO ON CurrentCycleEntriesEO.INVENTORY_ITEM_ID = PreviousCycleEntriesEO.INVENTORY_ITEM_ID AND

CurrentCycleEntriesEO.INVENTORY_ITEM_ORG_ID = PreviousCycleEntriesEO.INVENTORY_ITEM_ORG_ID AND

CurrentCycleEntriesEO.SHIP_TO_ID = PreviousCycleEntriesEO.SHIP_TO_ID AND

CurrentCycleEntriesEO.SHIP_FROM_ID = PreviousCycleEntriesEO.SHIP_FROM_ID AND

CurrentCycleEntriesEO.COLLAB_SOURCE_ID = PreviousCycleEntriesEO.COLLAB_SOURCE_ID AND

PreviousCycleEntriesEO.IS_CURRENT_FLAG = 'N'

LEFT JOIN VCS_PLANNING_SCH_DETAILS PreviousCycleDetailsEO ON PreviousCycleDetailsEO.COLLAB_ENTRY_ID =PreviousCycleEntriesEO.entry_id AND

PreviousCycleDetailsEO.IS_CURRENT_FLAG = 'Y'

WHERE CurrentCycleEntriesEO.IS_CURRENT_FLAG = 'Y'