View: MTL_CYCLE_COUNT_HEADERS_ALL_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_CYCLE_COUNT_HEADERS_ALL_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
, NVL(SERIAL_COUNT_OPTION
, 1) SERIAL_COUNT_OPTION
, SERIAL_DETAIL_OPTION
, SERIAL_ADJUSTMENT_OPTION
, SERIAL_DISCREPANCY_OPTION
, 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
, 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
WHERE TRUNC(NVL(DISABLE_DATE
, SYSDATE+1)) > TRUNC(SYSDATE)

Columns