VIEW: APPS.BOMFV_STD_FLOW_RTG_OPERATIONS

Source

View Text - Preformatted

SELECT OP.OPERATION_CODE OPERATION_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , OP.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY , OP.OPERATION_DESCRIPTION DESCRIPTION , OP.SEQUENCE_NUM SEQUENCE_NUMBER , '_LA:OP.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING' , '_LA:OP.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:OP.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , '_LA:OP.OPERATION_TYPE:MFG_LOOKUPS:BOM_OPERATION_TYPE:MEANING' , DE.DEPARTMENT_CODE DEPARTMENT_CODE , LI.LINE_CODE LINE_CODE , OP.STANDARD_OPERATION_ID STANDARD_OPERATION_ID , OP.ORGANIZATION_ID , OP.DEPARTMENT_ID , OP.LINE_ID , OP.LAST_UPDATE_DATE UPDATED_ON , OP.LAST_UPDATED_BY UPDATED_BY , OP.CREATION_DATE CREATED_ON , OP.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL, MTL_PARAMETERS PA, BOM_DEPARTMENTS DE, WIP_LINES LI, BOM_STANDARD_OPERATIONS OP WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.DEPARTMENT_ID = DE.DEPARTMENT_ID AND OP.LINE_ID = LI.LINE_ID AND LI.LINE_ID IS NOT NULL AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT OP.OPERATION_CODE OPERATION_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, OP.MINIMUM_TRANSFER_QUANTITY MINIMUM_TRANSFER_QUANTITY
, OP.OPERATION_DESCRIPTION DESCRIPTION
, OP.SEQUENCE_NUM SEQUENCE_NUMBER
, '_LA:OP.COUNT_POINT_TYPE:MFG_LOOKUPS:BOM_COUNT_POINT_TYPE:MEANING'
, '_LA:OP.BACKFLUSH_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.OPTION_DEPENDENT_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:OP.OPERATION_TYPE:MFG_LOOKUPS:BOM_OPERATION_TYPE:MEANING'
, DE.DEPARTMENT_CODE DEPARTMENT_CODE
, LI.LINE_CODE LINE_CODE
, OP.STANDARD_OPERATION_ID STANDARD_OPERATION_ID
, OP.ORGANIZATION_ID
, OP.DEPARTMENT_ID
, OP.LINE_ID
, OP.LAST_UPDATE_DATE UPDATED_ON
, OP.LAST_UPDATED_BY UPDATED_BY
, OP.CREATION_DATE CREATED_ON
, OP.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_DEPARTMENTS DE
, WIP_LINES LI
, BOM_STANDARD_OPERATIONS OP
WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.DEPARTMENT_ID = DE.DEPARTMENT_ID
AND OP.LINE_ID = LI.LINE_ID
AND LI.LINE_ID IS NOT NULL
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY