View: MTL_CYCLE_COUNT_HEADERS_VAL_V

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

View Text

SELECT "CYCLE_COUNT_HEADER_ID"
, "ORGANIZATION_ID"
, "LAST_UPDATE_DATE"
, "LAST_UPDATED_BY"
, "CREATION_DATE"
, "CREATED_BY"
, "LAST_UPDATE_LOGIN"
, "CYCLE_COUNT_HEADER_NAME"
, "INVENTORY_ADJUSTMENT_ACCOUNT"
, "ORIENTATION_CODE"
, "ABC_ASSIGNMENT_GROUP_ID"
, "ONHAND_VISIBLE_FLAG"
, "DAYS_UNTIL_LATE"
, "AUTOSCHEDULE_ENABLED_FLAG"
, "SCHEDULE_INTERVAL_TIME"
, "ZERO_COUNT_FLAG"
, "HEADER_LAST_SCHEDULE_DATE"
, "HEADER_NEXT_SCHEDULE_DATE"
, "DISABLE_DATE"
, "APPROVAL_OPTION_CODE"
, "AUTOMATIC_RECOUNT_FLAG"
, "NEXT_USER_COUNT_SEQUENCE"
, "UNSCHEDULED_COUNT_ENTRY"
, "CYCLE_COUNT_CALENDAR"
, "CALENDAR_EXCEPTION_SET"
, "APPROVAL_TOLERANCE_POSITIVE"
, "APPROVAL_TOLERANCE_NEGATIVE"
, "COST_TOLERANCE_POSITIVE"
, "COST_TOLERANCE_NEGATIVE"
, "HIT_MISS_TOLERANCE_POSITIVE"
, "HIT_MISS_TOLERANCE_NEGATIVE"
, "ABC_INITIALIZATION_STATUS"
, "DESCRIPTION"
, "REQUEST_ID"
, "PROGRAM_APPLICATION_ID"
, "PROGRAM_ID"
, "PROGRAM_UPDATE_DATE"
, "ATTRIBUTE_CATEGORY"
, "ATTRIBUTE1"
, "ATTRIBUTE2"
, "ATTRIBUTE3"
, "ATTRIBUTE4"
, "ATTRIBUTE5"
, "ATTRIBUTE6"
, "ATTRIBUTE7"
, "ATTRIBUTE8"
, "ATTRIBUTE9"
, "ATTRIBUTE10"
, "ATTRIBUTE11"
, "ATTRIBUTE12"
, "ATTRIBUTE13"
, "ATTRIBUTE14"
, "ATTRIBUTE15"
, "MAXIMUM_AUTO_RECOUNTS"
, NVL(SERIAL_COUNT_OPTION
, 1)
, "SERIAL_DETAIL_OPTION"
, "SERIAL_ADJUSTMENT_OPTION"
, "SERIAL_DISCREPANCY_OPTION"
, "CONTAINER_ENABLED_FLAG"
, "CONTAINER_ADJUSTMENT_OPTION"
, CONTAINER_DISCREPANCY_OPTION
, CYCLE_COUNT_TYPE
, SCHEDULE_EMPTY_LOCATIONS
, DEFAULT_NUM_COUNTS_PER_YEAR
FROM MTL_CYCLE_COUNT_HEADERS

Columns