[Home] [Help]
SELECT CC.ROWID ROW_ID , CC.CYCLE_COUNT_HEADER_ID , CC.ORGANIZATION_ID , CC.CYCLE_COUNT_HEADER_NAME , CC.INVENTORY_ADJUSTMENT_ACCOUNT , CC.ORIENTATION_CODE , MFG4.MEANING ORIENTATION , CC.ABC_ASSIGNMENT_GROUP_ID , ABC.ASSIGNMENT_GROUP_NAME ABC_ASSIGNMENT_GROUP , CC.ONHAND_VISIBLE_FLAG , CC.DAYS_UNTIL_LATE , CC.AUTOSCHEDULE_ENABLED_FLAG , CC.SCHEDULE_INTERVAL_TIME , MFG3.MEANING SCHEDULE_INTERVAL , CC.ZERO_COUNT_FLAG , CC.HEADER_LAST_SCHEDULE_DATE , CC.HEADER_NEXT_SCHEDULE_DATE , CC.DISABLE_DATE , CC.APPROVAL_OPTION_CODE , MFG2.MEANING APPROVAL_OPTION , CC.AUTOMATIC_RECOUNT_FLAG , CC.NEXT_USER_COUNT_SEQUENCE , CC.UNSCHEDULED_COUNT_ENTRY , CC.CYCLE_COUNT_CALENDAR , CC.CALENDAR_EXCEPTION_SET , CC.APPROVAL_TOLERANCE_POSITIVE , CC.APPROVAL_TOLERANCE_NEGATIVE , CC.COST_TOLERANCE_POSITIVE , CC.COST_TOLERANCE_NEGATIVE , CC.HIT_MISS_TOLERANCE_POSITIVE , CC.HIT_MISS_TOLERANCE_NEGATIVE , CC.ABC_INITIALIZATION_STATUS , MFG.MEANING ABC_INITIALIZATION_DUMMY ,NVL( CC.SERIAL_COUNT_OPTION, 1) , MFG5.MEANING SERIAL_COUNT_OPTION_MEANING , CC.SERIAL_DETAIL_OPTION , MFG6.MEANING SERIAL_DETAIL_OPTION_MEANING , CC.SERIAL_ADJUSTMENT_OPTION , MFG7.MEANING SERIAL_ADJ_OPTION_MEANING , CC.SERIAL_DISCREPANCY_OPTION , MFG8.MEANING SERIAL_DIS_OPTION_MEANING , CC.DESCRIPTION , CC.MAXIMUM_AUTO_RECOUNTS , CC.LAST_UPDATE_DATE , CC.LAST_UPDATED_BY , CC.CREATION_DATE , CC.CREATED_BY , CC.LAST_UPDATE_LOGIN , CC.REQUEST_ID , CC.PROGRAM_APPLICATION_ID , CC.PROGRAM_ID , CC.PROGRAM_UPDATE_DATE , CC.ATTRIBUTE_CATEGORY , CC.ATTRIBUTE1 , CC.ATTRIBUTE2 , CC.ATTRIBUTE3 , CC.ATTRIBUTE4 , CC.ATTRIBUTE5 , CC.ATTRIBUTE6 , CC.ATTRIBUTE7 , CC.ATTRIBUTE8 , CC.ATTRIBUTE9 , CC.ATTRIBUTE10 , CC.ATTRIBUTE11 , CC.ATTRIBUTE12 , CC.ATTRIBUTE13 , CC.ATTRIBUTE14 , CC.ATTRIBUTE15 , CC.CONTAINER_ENABLED_FLAG , CC.CONTAINER_ADJUSTMENT_OPTION , CC.CONTAINER_DISCREPANCY_OPTION , CC. CYCLE_COUNT_TYPE , CC.SCHEDULE_EMPTY_LOCATIONS , CC.DEFAULT_NUM_COUNTS_PER_YEAR FROM MTL_CYCLE_COUNT_HEADERS CC, MTL_ABC_ASSIGNMENT_GROUPS ABC, MFG_LOOKUPS MFG, MFG_LOOKUPS MFG2, MFG_LOOKUPS MFG3, MFG_LOOKUPS MFG4, MFG_LOOKUPS MFG5, MFG_LOOKUPS MFG6, MFG_LOOKUPS MFG7, MFG_LOOKUPS MFG8 WHERE CC.ABC_ASSIGNMENT_GROUP_ID = ABC.ASSIGNMENT_GROUP_ID (+) AND MFG.LOOKUP_TYPE (+) = 'MTL_CC_INITIALIZATION_STATUS' AND MFG.LOOKUP_CODE (+) = CC.ABC_INITIALIZATION_STATUS AND MFG2.LOOKUP_TYPE = 'MTL_APPROVAL_REQ' AND MFG2.LOOKUP_CODE = CC.APPROVAL_OPTION_CODE AND MFG3.LOOKUP_TYPE (+) = 'MTL_CC_SCHED_TIME' AND MFG3.LOOKUP_CODE (+) = CC.SCHEDULE_INTERVAL_TIME AND MFG4.LOOKUP_TYPE = 'MTL_CC_ORIENTATION' AND MFG4.LOOKUP_CODE = CC.ORIENTATION_CODE AND MFG5.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_COUNT_OPTIONS' AND MFG5.LOOKUP_CODE (+) = NVL(CC.SERIAL_COUNT_OPTION, 1) AND MFG6.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DETAIL_OPTIONS' AND MFG6.LOOKUP_CODE (+) = CC.SERIAL_DETAIL_OPTION AND MFG7.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_ADJ_OPTIONS' AND MFG7.LOOKUP_CODE (+) = CC.SERIAL_ADJUSTMENT_OPTION AND MFG8.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DISCREPY_OPTIONS' AND MFG8.LOOKUP_CODE (+) = CC.SERIAL_DISCREPANCY_OPTION
SELECT CC.ROWID ROW_ID
, CC.CYCLE_COUNT_HEADER_ID
, CC.ORGANIZATION_ID
, CC.CYCLE_COUNT_HEADER_NAME
, CC.INVENTORY_ADJUSTMENT_ACCOUNT
, CC.ORIENTATION_CODE
, MFG4.MEANING ORIENTATION
, CC.ABC_ASSIGNMENT_GROUP_ID
, ABC.ASSIGNMENT_GROUP_NAME ABC_ASSIGNMENT_GROUP
, CC.ONHAND_VISIBLE_FLAG
, CC.DAYS_UNTIL_LATE
, CC.AUTOSCHEDULE_ENABLED_FLAG
, CC.SCHEDULE_INTERVAL_TIME
, MFG3.MEANING SCHEDULE_INTERVAL
, CC.ZERO_COUNT_FLAG
, CC.HEADER_LAST_SCHEDULE_DATE
, CC.HEADER_NEXT_SCHEDULE_DATE
, CC.DISABLE_DATE
, CC.APPROVAL_OPTION_CODE
, MFG2.MEANING APPROVAL_OPTION
, CC.AUTOMATIC_RECOUNT_FLAG
, CC.NEXT_USER_COUNT_SEQUENCE
, CC.UNSCHEDULED_COUNT_ENTRY
, CC.CYCLE_COUNT_CALENDAR
, CC.CALENDAR_EXCEPTION_SET
, CC.APPROVAL_TOLERANCE_POSITIVE
, CC.APPROVAL_TOLERANCE_NEGATIVE
, CC.COST_TOLERANCE_POSITIVE
, CC.COST_TOLERANCE_NEGATIVE
, CC.HIT_MISS_TOLERANCE_POSITIVE
, CC.HIT_MISS_TOLERANCE_NEGATIVE
, CC.ABC_INITIALIZATION_STATUS
, MFG.MEANING ABC_INITIALIZATION_DUMMY
, NVL( CC.SERIAL_COUNT_OPTION
, 1)
, MFG5.MEANING SERIAL_COUNT_OPTION_MEANING
, CC.SERIAL_DETAIL_OPTION
, MFG6.MEANING SERIAL_DETAIL_OPTION_MEANING
, CC.SERIAL_ADJUSTMENT_OPTION
, MFG7.MEANING SERIAL_ADJ_OPTION_MEANING
, CC.SERIAL_DISCREPANCY_OPTION
, MFG8.MEANING SERIAL_DIS_OPTION_MEANING
, CC.DESCRIPTION
, CC.MAXIMUM_AUTO_RECOUNTS
, CC.LAST_UPDATE_DATE
, CC.LAST_UPDATED_BY
, CC.CREATION_DATE
, CC.CREATED_BY
, CC.LAST_UPDATE_LOGIN
, CC.REQUEST_ID
, CC.PROGRAM_APPLICATION_ID
, CC.PROGRAM_ID
, CC.PROGRAM_UPDATE_DATE
, CC.ATTRIBUTE_CATEGORY
, CC.ATTRIBUTE1
, CC.ATTRIBUTE2
, CC.ATTRIBUTE3
, CC.ATTRIBUTE4
, CC.ATTRIBUTE5
, CC.ATTRIBUTE6
, CC.ATTRIBUTE7
, CC.ATTRIBUTE8
, CC.ATTRIBUTE9
, CC.ATTRIBUTE10
, CC.ATTRIBUTE11
, CC.ATTRIBUTE12
, CC.ATTRIBUTE13
, CC.ATTRIBUTE14
, CC.ATTRIBUTE15
, CC.CONTAINER_ENABLED_FLAG
, CC.CONTAINER_ADJUSTMENT_OPTION
, CC.CONTAINER_DISCREPANCY_OPTION
, CC. CYCLE_COUNT_TYPE
, CC.SCHEDULE_EMPTY_LOCATIONS
, CC.DEFAULT_NUM_COUNTS_PER_YEAR
FROM MTL_CYCLE_COUNT_HEADERS CC
, MTL_ABC_ASSIGNMENT_GROUPS ABC
, MFG_LOOKUPS MFG
, MFG_LOOKUPS MFG2
, MFG_LOOKUPS MFG3
, MFG_LOOKUPS MFG4
, MFG_LOOKUPS MFG5
, MFG_LOOKUPS MFG6
, MFG_LOOKUPS MFG7
, MFG_LOOKUPS MFG8
WHERE CC.ABC_ASSIGNMENT_GROUP_ID = ABC.ASSIGNMENT_GROUP_ID (+)
AND MFG.LOOKUP_TYPE (+) = 'MTL_CC_INITIALIZATION_STATUS'
AND MFG.LOOKUP_CODE (+) = CC.ABC_INITIALIZATION_STATUS
AND MFG2.LOOKUP_TYPE = 'MTL_APPROVAL_REQ'
AND MFG2.LOOKUP_CODE = CC.APPROVAL_OPTION_CODE
AND MFG3.LOOKUP_TYPE (+) = 'MTL_CC_SCHED_TIME'
AND MFG3.LOOKUP_CODE (+) = CC.SCHEDULE_INTERVAL_TIME
AND MFG4.LOOKUP_TYPE = 'MTL_CC_ORIENTATION'
AND MFG4.LOOKUP_CODE = CC.ORIENTATION_CODE
AND MFG5.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_COUNT_OPTIONS'
AND MFG5.LOOKUP_CODE (+) = NVL(CC.SERIAL_COUNT_OPTION
, 1)
AND MFG6.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DETAIL_OPTIONS'
AND MFG6.LOOKUP_CODE (+) = CC.SERIAL_DETAIL_OPTION
AND MFG7.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_ADJ_OPTIONS'
AND MFG7.LOOKUP_CODE (+) = CC.SERIAL_ADJUSTMENT_OPTION
AND MFG8.LOOKUP_TYPE (+) = 'MTL_CC_SERIAL_DISCREPY_OPTIONS'
AND MFG8.LOOKUP_CODE (+) = CC.SERIAL_DISCREPANCY_OPTION
|
|
|
|