VIEW: APPS.MTL_CYCLE_COUNT_HEADERS_VAL_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" , "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

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"
, "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