VIEW: APPS.BOMFV_STD_OPRATN_RESOURCES

Source

View Text - Preformatted

SELECT ORE.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE_NUMBER , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , OP.OPERATION_CODE OPERATION_CODE , ORE.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT , ORE.USAGE_RATE_OR_AMOUNT_INVERSE INVERSE_RATE_OR_AMOUNT , ORE.ASSIGNED_UNITS ASSIGNED_UNITS , '_LA:ORE.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING' , '_LA:ORE.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING' , '_LA:ORE.SCHEDULE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:ORE.STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , AC.ACTIVITY , RE.RESOURCE_CODE , ORE.STANDARD_OPERATION_ID , ORE.RESOURCE_ID , ORE.ACTIVITY_ID , ORE.LAST_UPDATE_DATE UPDATED_ON , ORE.LAST_UPDATED_BY UPDATED_BY , ORE.CREATION_DATE CREATED_ON , ORE.CREATED_BY FROM BOM_STANDARD_OPERATIONS OP, HR_ALL_ORGANIZATION_UNITS AL, MTL_PARAMETERS PA, BOM_RESOURCES RE, CST_ACTIVITIES AC, BOM_STD_OP_RESOURCES ORE WHERE ORE.RESOURCE_ID = RE.RESOURCE_ID AND ORE.ACTIVITY_ID = AC.ACTIVITY_ID(+) AND PA.ORGANIZATION_ID = OP.ORGANIZATION_ID AND PA.ORGANIZATION_ID = AL.ORGANIZATION_ID AND ORE.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT ORE.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE_NUMBER
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, OP.OPERATION_CODE OPERATION_CODE
, ORE.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, ORE.USAGE_RATE_OR_AMOUNT_INVERSE INVERSE_RATE_OR_AMOUNT
, ORE.ASSIGNED_UNITS ASSIGNED_UNITS
, '_LA:ORE.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:ORE.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:ORE.SCHEDULE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:ORE.STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, AC.ACTIVITY
, RE.RESOURCE_CODE
, ORE.STANDARD_OPERATION_ID
, ORE.RESOURCE_ID
, ORE.ACTIVITY_ID
, ORE.LAST_UPDATE_DATE UPDATED_ON
, ORE.LAST_UPDATED_BY UPDATED_BY
, ORE.CREATION_DATE CREATED_ON
, ORE.CREATED_BY
FROM BOM_STANDARD_OPERATIONS OP
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_RESOURCES RE
, CST_ACTIVITIES AC
, BOM_STD_OP_RESOURCES ORE
WHERE ORE.RESOURCE_ID = RE.RESOURCE_ID
AND ORE.ACTIVITY_ID = AC.ACTIVITY_ID(+)
AND PA.ORGANIZATION_ID = OP.ORGANIZATION_ID
AND PA.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND ORE.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY