VIEW: APPS.MTL_CYCLE_COUNT_HEADERS_ALL_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)