View: INVFV_CYCLE_COUNT_ITEMS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVFV_CYCLE_COUNT_ITEMS

View Text

SELECT MCI.CYCLE_COUNT_HEADER_ID
, MCH.CYCLE_COUNT_HEADER_NAME
, MCI.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI' /* KEYFLEX */
, MCH.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MCI.ABC_CLASS_ID
, MAC.ABC_CLASS_NAME
, MCI.ITEM_LAST_SCHEDULE_DATE
, MCI.SCHEDULE_ORDER
, MCI.APPROVAL_TOLERANCE_POSITIVE
, MCI.APPROVAL_TOLERANCE_NEGATIVE
, '_LA:MCI.CONTROL_GROUP_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' /* LOOKUP */
, MCI.CREATED_BY
, MCI.CREATION_DATE
, MCI.LAST_UPDATED_BY
, MCI.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_ABC_CLASSES MAC
, MTL_CYCLE_COUNT_HEADERS MCH
, MTL_SYSTEM_ITEMS MSI
, MTL_CYCLE_COUNT_ITEMS MCI
WHERE MCH.CYCLE_COUNT_HEADER_ID = MCI.CYCLE_COUNT_HEADER_ID
AND MSI.INVENTORY_ITEM_ID = MCI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MCH.ORGANIZATION_ID
AND MAC.ABC_CLASS_ID = MCI.ABC_CLASS_ID
AND MP.ORGANIZATION_ID = MCH.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MCH.ORGANIZATION_ID
AND '_SEC:MCH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns