Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMBV_STD_OPRATN_RESOURCES |
SELECT RE.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE_NUMBER
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, OP.OPERATION_CODE OPERATION_CODE
, RE.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, RE.USAGE_RATE_OR_AMOUNT_INVERSE INVERSE_RATE_OR_AMOUNT
, RE.ASSIGNED_UNITS ASSIGNED_UNITS
, '_LA:RE.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:RE.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:RE.SCHEDULE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:RE.STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, RE.STANDARD_OPERATION_ID
, RE.RESOURCE_ID
, RE.ACTIVITY_ID
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY
FROM BOM_STD_OP_RESOURCES RE
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_STANDARD_OPERATIONS OP
WHERE PA.ORGANIZATION_ID = OP.ORGANIZATION_ID
AND AL.ORGANIZATION_ID = OP.ORGANIZATION_ID
AND RE.STANDARD_OPERATION_ID = OP.STANDARD_OPERATION_ID
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY