View: INVFV_CYCLE_COUNT_CLASSES

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

View Text

SELECT MCC.CYCLE_COUNT_HEADER_ID
, MCH.CYCLE_COUNT_HEADER_NAME
, MCC.ABC_ASSIGNMENT_GROUP_ID
, MAG.ASSIGNMENT_GROUP_NAME
, MCC.ABC_CLASS_ID
, MAC.ABC_CLASS_NAME
, MCC.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MCC.NUM_COUNTS_PER_YEAR
, MCC.APPROVAL_TOLERANCE_POSITIVE
, MCC.APPROVAL_TOLERANCE_NEGATIVE
, MCC.COST_TOLERANCE_POSITIVE
, MCC.COST_TOLERANCE_NEGATIVE
, MCC.HIT_MISS_TOLERANCE_POSITIVE
, MCC.HIT_MISS_TOLERANCE_NEGATIVE
, MCC.CREATED_BY
, MCC.CREATION_DATE
, MCC.LAST_UPDATED_BY
, MCC.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_CYCLE_COUNT_HEADERS MCH
, MTL_ABC_ASSIGNMENT_GROUPS MAG
, MTL_ABC_CLASSES MAC
, MTL_CYCLE_COUNT_CLASSES MCC
WHERE MAC.ABC_CLASS_ID = MCC.ABC_CLASS_ID
AND MAG.ASSIGNMENT_GROUP_ID (+) = MCC.ABC_ASSIGNMENT_GROUP_ID
AND MP.ORGANIZATION_ID = MCC.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MCC.ORGANIZATION_ID
AND MCH.CYCLE_COUNT_HEADER_ID (+) = MCC.CYCLE_COUNT_HEADER_ID
AND '_SEC:MCC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns