VIEW: APPS.EAM_CFR_RESOURCES_V

Source

View Text - Preformatted

SELECT WOR.WIP_ENTITY_ID , WOR.OPERATION_SEQ_NUM , WOR.RESOURCE_SEQ_NUM , BR.RESOURCE_CODE , BR.DESCRIPTION, BR.PURCHASE_ITEM_ID , WOR.ORGANIZATION_ID , WOR.REPETITIVE_SCHEDULE_ID , WOR.RESOURCE_ID , WOR.UOM_CODE , WOR.BASIS_TYPE , ML1.MEANING AS BASIS_TYPE_DISP, ROUND(WOR.USAGE_RATE_OR_AMOUNT, 6) , WOR.ACTIVITY_ID , WOR.SCHEDULED_FLAG , ML2.MEANING AS SCHEDULED_FLAG_DISP, WOR.ASSIGNED_UNITS , WOR.AUTOCHARGE_TYPE , ML3.MEANING AS AUTOCHARGE_TYPE_DISP, WOR.STANDARD_RATE_FLAG , ML4.MEANING AS STANDARD_RATE_FLAG_DISP, DECODE(SIGN(WOR.APPLIED_RESOURCE_UNITS),1,WOR.APPLIED_RESOURCE_UNITS, -1,WOR.APPLIED_RESOURCE_UNITS, NULL), WOR.APPLIED_RESOURCE_VALUE , WOR.START_DATE , WOR.COMPLETION_DATE , WOR.ATTRIBUTE_CATEGORY , WOR.ATTRIBUTE1 , WOR.ATTRIBUTE2 , WOR.ATTRIBUTE3 , WOR.ATTRIBUTE4 , WOR.ATTRIBUTE5 , WOR.ATTRIBUTE6 , WOR.ATTRIBUTE7 , WOR.ATTRIBUTE8 , WOR.ATTRIBUTE9 , WOR.ATTRIBUTE10 , WOR.ATTRIBUTE11 , WOR.ATTRIBUTE12 , WOR.ATTRIBUTE13 , WOR.ATTRIBUTE14 , WOR.ATTRIBUTE15 , WOR.DEPARTMENT_ID , WOR.PHANTOM_FLAG , BD.DEPARTMENT_CODE , WOR.PHANTOM_OP_SEQ_NUM , WOR.PHANTOM_ITEM_ID , BR.RESOURCE_TYPE , ML1.meaning resource_type_disp, WOR.SCHEDULE_SEQ_NUM , WOR.SUBSTITUTE_GROUP_NUM , WOR.REPLACEMENT_GROUP_NUM , WOR.PRINCIPLE_FLAG , WOR.SETUP_ID , WOR.PARENT_RESOURCE_SEQ , WOR.BATCH_ID , WOR.FIRM_FLAG , WOR.GROUP_SEQUENCE_ID , WOR.GROUP_SEQUENCE_NUMBER , WOR.MAXIMUM_ASSIGNED_UNITS FROM BOM_RESOURCES BR , WIP_OPERATION_RESOURCES WOR , BOM_DEPARTMENTS BD, MFG_LOOKUPS ML1, MFG_LOOKUPS ML2, MFG_LOOKUPS ML3, MFG_LOOKUPS ML4, MFG_LOOKUPS ML5 WHERE BR.RESOURCE_ID = WOR.RESOURCE_ID AND BD.DEPARTMENT_ID (+) = WOR.DEPARTMENT_ID AND ML1.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE' AND ML1.LOOKUP_CODE (+) = BR.resource_type AND ML2.LOOKUP_TYPE = 'CST_BASIS' AND ML2.LOOKUP_CODE = WOR.BASIS_TYPE AND ML3.LOOKUP_TYPE = 'BOM_RESOURCE_SCHEDULE_TYPE' AND ML3.LOOKUP_CODE = WOR.SCHEDULED_FLAG AND ML4.LOOKUP_TYPE = 'BOM_AUTOCHARGE_TYPE' AND ML4.LOOKUP_CODE = WOR.AUTOCHARGE_TYPE AND ML5.LOOKUP_TYPE = 'SYS_YES_NO' AND ML5.LOOKUP_CODE = WOR.STANDARD_RATE_FLAG

View Text - HTML Formatted

SELECT WOR.WIP_ENTITY_ID
, WOR.OPERATION_SEQ_NUM
, WOR.RESOURCE_SEQ_NUM
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BR.PURCHASE_ITEM_ID
, WOR.ORGANIZATION_ID
, WOR.REPETITIVE_SCHEDULE_ID
, WOR.RESOURCE_ID
, WOR.UOM_CODE
, WOR.BASIS_TYPE
, ML1.MEANING AS BASIS_TYPE_DISP
, ROUND(WOR.USAGE_RATE_OR_AMOUNT
, 6)
, WOR.ACTIVITY_ID
, WOR.SCHEDULED_FLAG
, ML2.MEANING AS SCHEDULED_FLAG_DISP
, WOR.ASSIGNED_UNITS
, WOR.AUTOCHARGE_TYPE
, ML3.MEANING AS AUTOCHARGE_TYPE_DISP
, WOR.STANDARD_RATE_FLAG
, ML4.MEANING AS STANDARD_RATE_FLAG_DISP
, DECODE(SIGN(WOR.APPLIED_RESOURCE_UNITS)
, 1
, WOR.APPLIED_RESOURCE_UNITS
, -1
, WOR.APPLIED_RESOURCE_UNITS
, NULL)
, WOR.APPLIED_RESOURCE_VALUE
, WOR.START_DATE
, WOR.COMPLETION_DATE
, WOR.ATTRIBUTE_CATEGORY
, WOR.ATTRIBUTE1
, WOR.ATTRIBUTE2
, WOR.ATTRIBUTE3
, WOR.ATTRIBUTE4
, WOR.ATTRIBUTE5
, WOR.ATTRIBUTE6
, WOR.ATTRIBUTE7
, WOR.ATTRIBUTE8
, WOR.ATTRIBUTE9
, WOR.ATTRIBUTE10
, WOR.ATTRIBUTE11
, WOR.ATTRIBUTE12
, WOR.ATTRIBUTE13
, WOR.ATTRIBUTE14
, WOR.ATTRIBUTE15
, WOR.DEPARTMENT_ID
, WOR.PHANTOM_FLAG
, BD.DEPARTMENT_CODE
, WOR.PHANTOM_OP_SEQ_NUM
, WOR.PHANTOM_ITEM_ID
, BR.RESOURCE_TYPE
, ML1.MEANING RESOURCE_TYPE_DISP
, WOR.SCHEDULE_SEQ_NUM
, WOR.SUBSTITUTE_GROUP_NUM
, WOR.REPLACEMENT_GROUP_NUM
, WOR.PRINCIPLE_FLAG
, WOR.SETUP_ID
, WOR.PARENT_RESOURCE_SEQ
, WOR.BATCH_ID
, WOR.FIRM_FLAG
, WOR.GROUP_SEQUENCE_ID
, WOR.GROUP_SEQUENCE_NUMBER
, WOR.MAXIMUM_ASSIGNED_UNITS
FROM BOM_RESOURCES BR
, WIP_OPERATION_RESOURCES WOR
, BOM_DEPARTMENTS BD
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MFG_LOOKUPS ML5
WHERE BR.RESOURCE_ID = WOR.RESOURCE_ID
AND BD.DEPARTMENT_ID (+) = WOR.DEPARTMENT_ID
AND ML1.LOOKUP_TYPE (+) = 'BOM_RESOURCE_TYPE'
AND ML1.LOOKUP_CODE (+) = BR.RESOURCE_TYPE
AND ML2.LOOKUP_TYPE = 'CST_BASIS'
AND ML2.LOOKUP_CODE = WOR.BASIS_TYPE
AND ML3.LOOKUP_TYPE = 'BOM_RESOURCE_SCHEDULE_TYPE'
AND ML3.LOOKUP_CODE = WOR.SCHEDULED_FLAG
AND ML4.LOOKUP_TYPE = 'BOM_AUTOCHARGE_TYPE'
AND ML4.LOOKUP_CODE = WOR.AUTOCHARGE_TYPE
AND ML5.LOOKUP_TYPE = 'SYS_YES_NO'
AND ML5.LOOKUP_CODE = WOR.STANDARD_RATE_FLAG