VIEW: INV.MTL_CYCLE_COUNT_CLASSES#

Source

View Text - Preformatted

select ABC_CLASS_ID ABC_CLASS_ID, CYCLE_COUNT_HEADER_ID CYCLE_COUNT_HEADER_ID, ORGANIZATION_ID ORGANIZATION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, NUM_COUNTS_PER_YEAR NUM_COUNTS_PER_YEAR, APPROVAL_TOLERANCE_POSITIVE APPROVAL_TOLERANCE_POSITIVE, APPROVAL_TOLERANCE_NEGATIVE APPROVAL_TOLERANCE_NEGATIVE, COST_TOLERANCE_POSITIVE COST_TOLERANCE_POSITIVE, COST_TOLERANCE_NEGATIVE COST_TOLERANCE_NEGATIVE, HIT_MISS_TOLERANCE_POSITIVE HIT_MISS_TOLERANCE_POSITIVE, HIT_MISS_TOLERANCE_NEGATIVE HIT_MISS_TOLERANCE_NEGATIVE, ABC_ASSIGNMENT_GROUP_ID ABC_ASSIGNMENT_GROUP_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "INV"."MTL_CYCLE_COUNT_CLASSES"

View Text - HTML Formatted

SELECT ABC_CLASS_ID ABC_CLASS_ID
, CYCLE_COUNT_HEADER_ID CYCLE_COUNT_HEADER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, NUM_COUNTS_PER_YEAR NUM_COUNTS_PER_YEAR
, APPROVAL_TOLERANCE_POSITIVE APPROVAL_TOLERANCE_POSITIVE
, APPROVAL_TOLERANCE_NEGATIVE APPROVAL_TOLERANCE_NEGATIVE
, COST_TOLERANCE_POSITIVE COST_TOLERANCE_POSITIVE
, COST_TOLERANCE_NEGATIVE COST_TOLERANCE_NEGATIVE
, HIT_MISS_TOLERANCE_POSITIVE HIT_MISS_TOLERANCE_POSITIVE
, HIT_MISS_TOLERANCE_NEGATIVE HIT_MISS_TOLERANCE_NEGATIVE
, ABC_ASSIGNMENT_GROUP_ID ABC_ASSIGNMENT_GROUP_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "INV"."MTL_CYCLE_COUNT_CLASSES"