VIEW: APPS.INVFV_CYCLE_COUNTS

Source

View Text - Preformatted

SELECT MCH.CYCLE_COUNT_HEADER_ID , MCH.CYCLE_COUNT_HEADER_NAME , MCH.DESCRIPTION , MCH.ORGANIZATION_ID , MP.ORGANIZATION_CODE , HOU.NAME , MCH.INVENTORY_ADJUSTMENT_ACCOUNT, '_KF:SQLGL:GL#:GLC', /* KEYFLEX */ '_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 GL_CODE_COMBINATIONS GLC, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS HOU, MTL_CYCLE_COUNT_HEADERS MCH WHERE MP.ORGANIZATION_ID = MCH.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MCH.ORGANIZATION_ID AND GLC.CODE_COMBINATION_ID = MCH.INVENTORY_ADJUSTMENT_ACCOUNT AND '_SEC:MCH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MCH.CYCLE_COUNT_HEADER_ID
, MCH.CYCLE_COUNT_HEADER_NAME
, MCH.DESCRIPTION
, MCH.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MCH.INVENTORY_ADJUSTMENT_ACCOUNT
, '_KF:SQLGL:GL#:GLC'
, /* KEYFLEX */ '_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 GL_CODE_COMBINATIONS GLC
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_CYCLE_COUNT_HEADERS MCH
WHERE MP.ORGANIZATION_ID = MCH.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MCH.ORGANIZATION_ID
AND GLC.CODE_COMBINATION_ID = MCH.INVENTORY_ADJUSTMENT_ACCOUNT
AND '_SEC:MCH.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY