View: MTL_CYCLE_COUNT_HEADERS_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_CYCLE_COUNT_HEADERS_V

View Text

SELECT CC.ROWID ROW_ID
, CC.CYCLE_COUNT_HEADER_ID
, CC.ORGANIZATION_ID
, CC.CYCLE_COUNT_HEADER_NAME
, CC.INVENTORY_ADJUSTMENT_ACCOUNT
, CC.ORIENTATION_CODE
, MFG4.MEANING ORIENTATION
, CC.ABC_ASSIGNMENT_GROUP_ID
, ABC.ASSIGNMENT_GROUP_NAME ABC_ASSIGNMENT_GROUP
, CC.ONHAND_VISIBLE_FLAG
, CC.DAYS_UNTIL_LATE
, CC.AUTOSCHEDULE_ENABLED_FLAG
, CC.SCHEDULE_INTERVAL_TIME
, MFG3.MEANING SCHEDULE_INTERVAL
, CC.ZERO_COUNT_FLAG
, CC.HEADER_LAST_SCHEDULE_DATE
, CC.HEADER_NEXT_SCHEDULE_DATE
, CC.DISABLE_DATE
, CC.APPROVAL_OPTION_CODE
, MFG2.MEANING APPROVAL_OPTION
, CC.AUTOMATIC_RECOUNT_FLAG
, CC.NEXT_USER_COUNT_SEQUENCE
, CC.UNSCHEDULED_COUNT_ENTRY
, CC.CYCLE_COUNT_CALENDAR
, CC.CALENDAR_EXCEPTION_SET
, CC.APPROVAL_TOLERANCE_POSITIVE
, CC.APPROVAL_TOLERANCE_NEGATIVE
, CC.COST_TOLERANCE_POSITIVE
, CC.COST_TOLERANCE_NEGATIVE
, CC.HIT_MISS_TOLERANCE_POSITIVE
, CC.HIT_MISS_TOLERANCE_NEGATIVE
, CC.ABC_INITIALIZATION_STATUS
, MFG.MEANING ABC_INITIALIZATION_DUMMY
, NVL( CC.SERIAL_COUNT_OPTION
, 1)
, MFG5.MEANING SERIAL_COUNT_OPTION_MEANING
, CC.SERIAL_DETAIL_OPTION
, MFG6.MEANING SERIAL_DETAIL_OPTION_MEANING
, CC.SERIAL_ADJUSTMENT_OPTION
, MFG7.MEANING SERIAL_ADJ_OPTION_MEANING
, CC.SERIAL_DISCREPANCY_OPTION
, MFG8.MEANING SERIAL_DIS_OPTION_MEANING
, CC.DESCRIPTION
, CC.MAXIMUM_AUTO_RECOUNTS
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
, CC.CREATION_DATE
, CC.CREATED_BY
, CC.LAST_UPDATE_LOGIN
, CC.REQUEST_ID
, CC.PROGRAM_APPLICATION_ID
, CC.PROGRAM_ID
, CC.PROGRAM_UPDATE_DATE
, CC.ATTRIBUTE_CATEGORY
, CC.ATTRIBUTE1
, CC.ATTRIBUTE2
, CC.ATTRIBUTE3
, CC.ATTRIBUTE4
, CC.ATTRIBUTE5
, CC.ATTRIBUTE6
, CC.ATTRIBUTE7
, CC.ATTRIBUTE8
, CC.ATTRIBUTE9
, CC.ATTRIBUTE10
, CC.ATTRIBUTE11
, CC.ATTRIBUTE12
, CC.ATTRIBUTE13
, CC.ATTRIBUTE14
, CC.ATTRIBUTE15
, CC.CONTAINER_ENABLED_FLAG
, CC.CONTAINER_ADJUSTMENT_OPTION
, CC.CONTAINER_DISCREPANCY_OPTION
, CC. CYCLE_COUNT_TYPE
, CC.SCHEDULE_EMPTY_LOCATIONS
, CC.DEFAULT_NUM_COUNTS_PER_YEAR
FROM MTL_CYCLE_COUNT_HEADERS CC
, MTL_ABC_ASSIGNMENT_GROUPS ABC
, MFG_LOOKUPS MFG
, MFG_LOOKUPS MFG2
, MFG_LOOKUPS MFG3
, MFG_LOOKUPS MFG4
, MFG_LOOKUPS MFG5
, MFG_LOOKUPS MFG6
, MFG_LOOKUPS MFG7
, MFG_LOOKUPS MFG8
WHERE CC.ABC_ASSIGNMENT_GROUP_ID = ABC.ASSIGNMENT_GROUP_ID (+)
AND MFG.LOOKUP_TYPE (+) = 'MTL_CC_INITIALIZATION_STATUS'
AND MFG.LOOKUP_CODE (+) = CC.ABC_INITIALIZATION_STATUS
AND MFG2.LOOKUP_TYPE = 'MTL_APPROVAL_REQ'
AND MFG2.LOOKUP_CODE = CC.APPROVAL_OPTION_CODE
AND MFG3.LOOKUP_TYPE (+) = 'MTL_CC_SCHED_TIME'
AND MFG3.LOOKUP_CODE (+) = CC.SCHEDULE_INTERVAL_TIME
AND MFG4.LOOKUP_TYPE = 'MTL_CC_ORIENTATION'
AND MFG4.LOOKUP_CODE = CC.ORIENTATION_CODE
AND MFG5.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_COUNT_OPTIONS'
AND MFG5.LOOKUP_CODE (+) = NVL(CC.SERIAL_COUNT_OPTION
, 1)
AND MFG6.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DETAIL_OPTIONS'
AND MFG6.LOOKUP_CODE (+) = CC.SERIAL_DETAIL_OPTION
AND MFG7.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_ADJ_OPTIONS'
AND MFG7.LOOKUP_CODE (+) = CC.SERIAL_ADJUSTMENT_OPTION
AND MFG8.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DISCREPY_OPTIONS'
AND MFG8.LOOKUP_CODE (+) = CC.SERIAL_DISCREPANCY_OPTION

Columns