VIEW: APPS.BOMFV_MANUFACTURING_LINES

Source

View Text - Preformatted

SELECT LI.LINE_CODE LINE_NAME , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , LI.DESCRIPTION DESCRIPTION , LI.DISABLE_DATE INACTIVE_DATE , LI.MINIMUM_RATE MINIMUM_HOURLY_RATE , LI.MAXIMUM_RATE MAXIMUM_HOURLY_RATE , LI.FIXED_THROUGHPUT FIXED_LEAD_TIME , LI.START_TIME LINE_START_TIME , LI.STOP_TIME LINE_STOP_TIME , '_LA:LI.LINE_SCHEDULE_TYPE:MFG_LOOKUPS:WIP_LINE_SCHED_TYPE:MEANING' , AT.RULE_NAME , LI.ORGANIZATION_ID , LI.LINE_ID , LI.ATP_RULE_ID , LI.EXCEPTION_SET_NAME , LI.LAST_UPDATE_DATE UPDATED_ON , LI.LAST_UPDATED_BY UPDATED_BY , LI.CREATION_DATE CREATED_ON , LI.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL,MTL_PARAMETERS PA,MTL_ATP_RULES AT,WIP_LINES LI WHERE LI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND LI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LI.ATP_RULE_ID = AT.RULE_ID(+) AND '_SEC:LI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT LI.LINE_CODE LINE_NAME
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, LI.DESCRIPTION DESCRIPTION
, LI.DISABLE_DATE INACTIVE_DATE
, LI.MINIMUM_RATE MINIMUM_HOURLY_RATE
, LI.MAXIMUM_RATE MAXIMUM_HOURLY_RATE
, LI.FIXED_THROUGHPUT FIXED_LEAD_TIME
, LI.START_TIME LINE_START_TIME
, LI.STOP_TIME LINE_STOP_TIME
, '_LA:LI.LINE_SCHEDULE_TYPE:MFG_LOOKUPS:WIP_LINE_SCHED_TYPE:MEANING'
, AT.RULE_NAME
, LI.ORGANIZATION_ID
, LI.LINE_ID
, LI.ATP_RULE_ID
, LI.EXCEPTION_SET_NAME
, LI.LAST_UPDATE_DATE UPDATED_ON
, LI.LAST_UPDATED_BY UPDATED_BY
, LI.CREATION_DATE CREATED_ON
, LI.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, MTL_ATP_RULES AT
, WIP_LINES LI
WHERE LI.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND LI.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND LI.ATP_RULE_ID = AT.RULE_ID(+)
AND '_SEC:LI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY