View: INVBV_CYCLE_COUNTS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_CYCLE_COUNTS

View Text

SELECT MCH.CYCLE_COUNT_HEADER_ID
, MCH.CYCLE_COUNT_HEADER_NAME
, MCH.DESCRIPTION
, MCH.ORGANIZATION_ID
, MCH.INVENTORY_ADJUSTMENT_ACCOUNT
, '_LA:MCH.ORIENTATION_CODE:MFG_LOOKUPS:MTL_CC_ORIENTATION:MEANING'
, /* LOOKUP */ MCH.ABC_ASSIGNMENT_GROUP_ID
, '_LA:MCH.ABC_INITIALIZATION_STATUS:MFG_LOOKUPS:MTL_CC_INITIALIZATION_STATUS:MEANING'
, /* LOOKUP */ '_LA:MCH.SCHEDULE_INTERVAL_TIME:MFG_LOOKUPS:MTL_CC_SCHED_TIME:MEANING' /* LOOKUP */
, MCH.HEADER_LAST_SCHEDULE_DATE
, MCH.HEADER_NEXT_SCHEDULE_DATE
, MCH.DISABLE_DATE
, MCH.NEXT_USER_COUNT_SEQUENCE
, MCH.CYCLE_COUNT_CALENDAR
, MCH.CALENDAR_EXCEPTION_SET
, MCH.APPROVAL_TOLERANCE_POSITIVE
, MCH.APPROVAL_TOLERANCE_NEGATIVE
, MCH.COST_TOLERANCE_POSITIVE
, MCH.COST_TOLERANCE_NEGATIVE
, MCH.HIT_MISS_TOLERANCE_POSITIVE
, MCH.HIT_MISS_TOLERANCE_NEGATIVE
, '_LA:MCH.AUTOMATIC_RECOUNT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ MCH.MAXIMUM_AUTO_RECOUNTS
, '_LA:MCH.SERIAL_COUNT_OPTION:MFG_LOOKUPS:MTL_CC_SERIAL_COUNT_OPTIONS:MEANING'
, /* LOOKUP */'_LA:MCH.SERIAL_DETAIL_OPTION:MFG_LOOKUPS:MTL_CC_SERIAL_DETAIL_OPTIONS:MEANING'
, /* LOOKUP */ '_LA:MCH.SERIAL_ADJUSTMENT_OPTION:MFG_LOOKUPS:MTL_CC_SERIAL_ADJ_OPTIONS:MEANING'
, /* LOOKUP */ '_LA:MCH.SERIAL_DISCREPANCY_OPTION:MFG_LOOKUPS:MTL_CC_SERIAL_DISCREPY_OPTIONS:MEANING'
, /* LOOKUP */ '_LA:MCH.UNSCHEDULED_COUNT_ENTRY:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ MCH.DAYS_UNTIL_LATE
, '_LA:MCH.AUTOSCHEDULE_ENABLED_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MCH.APPROVAL_OPTION_CODE:MFG_LOOKUPS:MTL_APPROVAL_REQ:MEANING'
, /* LOOKUP */ '_LA:MCH.ZERO_COUNT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, /* LOOKUP */ '_LA:MCH.ONHAND_VISIBLE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' /* LOOKUP */
, MCH.CREATED_BY
, MCH.CREATION_DATE
, MCH.LAST_UPDATED_BY
, MCH.LAST_UPDATE_DATE
FROM MTL_CYCLE_COUNT_HEADERS MCH
WHERE '_SEC:MCH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns