[Home] [Help]
View: MRPBV_MPS_ITEMS
Product: | MRP - Master Scheduling/MRP |
Description: | - Retrofitted |
Implementation/DBA Data: |
APPS.MRPBV_MPS_ITEMS
|
View Text
SELECT PA.ORGANIZATION_CODE
, AL.NAME
, SCIT.SCHEDULE_DESIGNATOR
, '_KF:INV:MSTK:SY'
, SCIT.ORGANIZATION_ID
, SCIT.INVENTORY_ITEM_ID
, SCIT.LAST_UPDATE_DATE
, SCIT.LAST_UPDATED_BY
, SCIT.CREATION_DATE
, SCIT.CREATED_BY
FROM BOM_CALENDAR_DATES CAL1
, BOM_CALENDAR_DATES CAL2
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MRP_SCHEDULE_DESIGNATORS SC
, MRP_SCHEDULE_ITEMS SCIT
WHERE SCIT.ORGANIZATION_ID = SC.ORGANIZATION_ID
AND SCIT.SCHEDULE_DESIGNATOR = SC.SCHEDULE_DESIGNATOR
AND SC.SCHEDULE_TYPE = 2
AND SCIT.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND SCIT.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND SCIT.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND SCIT.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND CAL2.EXCEPTION_SET_ID = PA.CALENDAR_EXCEPTION_SET_ID
AND CAL2.CALENDAR_CODE = PA.CALENDAR_CODE
AND CAL1.EXCEPTION_SET_ID = PA.CALENDAR_EXCEPTION_SET_ID
AND CAL1.CALENDAR_CODE = PA.CALENDAR_CODE
AND CAL1.CALENDAR_DATE = TRUNC(SYSDATE)
AND CAL2.SEQ_NUM = CAL1.PRIOR_SEQ_NUM + DECODE(SY.PLANNING_TIME_FENCE_CODE
, 1
, NVL(SY.CUMULATIVE_TOTAL_LEAD_TIME
, 0)
, 2
, NVL(SY.CUM_MANUFACTURING_LEAD_TIME
, 0)
, 3
, NVL(SY.FULL_LEAD_TIME
, 0)
, 4
, NVL(SY.PLANNING_TIME_FENCE_DAYS
, 0))
AND '_SEC:SCIT.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY
Columns
Name |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
SCHEDULE_NAME |
"_KF:ITEM_NUMBER" |
ORGANIZATION_ID |
INVENTORY_ITEM_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |