VIEW: APPS.BOMFV_ENGINEERING_BOMS

Source

View Text - Preformatted

SELECT BI1.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE , PA1.ORGANIZATION_CODE ORGANIZATION_CODE , AL1.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY1' "_KF:BILL_ITEM_NAME" , BI1.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION , BI1.PENDING_FROM_ECN PENDING_FROM_ECO , PA2.ORGANIZATION_CODE COMMON_ORGANIZATION_CODE , AL2.NAME COMMON_ORGANIZATION_NAME , '_KF:INV:MSTK:SY2' "_KF:COMMON_BILL_ITEM_NAME" , PR.NAME PROJECT_NAME , TA.TASK_NUMBER TASK_NAME , '_DF:BOM:BOM_BILL_OF_MATERIALS:BI1' , BI1.ASSEMBLY_ITEM_ID , BI1.ORGANIZATION_ID , BI1.BILL_SEQUENCE_ID , Bi2.ALTERNATE_BOM_DESIGNATOR , BI1.COMMON_ASSEMBLY_ITEM_ID , BI1.COMMON_BILL_SEQUENCE_ID , BI1.COMMON_ORGANIZATION_ID , BI1.PROJECT_ID , BI1.TASK_ID , BI1.LAST_UPDATE_DATE UPDATED_ON , BI1.LAST_UPDATED_BY UPDATED_BY , BI1.CREATION_DATE CREATED_ON , BI1.CREATED_BY FROM HR_ALL_ORGANIZATION_UNITS AL2, HR_ALL_ORGANIZATION_UNITS AL1, MTL_PARAMETERS PA1, MTL_SYSTEM_ITEMS SY1, BOM_BILL_OF_MATERIALS BI2, MTL_PARAMETERS PA2, MTL_SYSTEM_ITEMS SY2, PA_TASKS TA, PA_PROJECTS_ALL PR, BOM_BILL_OF_MATERIALS BI1 WHERE BI1.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND BI1.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND BI1.ORGANIZATION_ID =PA1.ORGANIZATION_ID AND BI1.ORGANIZATION_ID =AL1.ORGANIZATION_ID AND BI1.COMMON_BILL_SEQUENCE_ID = BI2.BILL_SEQUENCE_ID(+) AND BI1.COMMON_ORGANIZATION_ID = SY2.ORGANIZATION_ID(+) AND BI1.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+) AND BI1.COMMON_ORGANIZATION_ID = PA2.ORGANIZATION_ID(+) AND BI1.ORGANIZATION_ID = AL2.ORGANIZATION_ID AND BI1.PROJECT_ID = PR.PROJECT_ID(+) AND BI1.TASK_ID = TA.TASK_ID(+) AND BI1.ASSEMBLY_TYPE = 2 AND '_SEC:BI1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT BI1.ALTERNATE_BOM_DESIGNATOR ALTERNATE_BOM_CODE
, PA1.ORGANIZATION_CODE ORGANIZATION_CODE
, AL1.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY1' "_KF:BILL_ITEM_NAME"
, BI1.SPECIFIC_ASSEMBLY_COMMENT DESCRIPTION
, BI1.PENDING_FROM_ECN PENDING_FROM_ECO
, PA2.ORGANIZATION_CODE COMMON_ORGANIZATION_CODE
, AL2.NAME COMMON_ORGANIZATION_NAME
, '_KF:INV:MSTK:SY2' "_KF:COMMON_BILL_ITEM_NAME"
, PR.NAME PROJECT_NAME
, TA.TASK_NUMBER TASK_NAME
, '_DF:BOM:BOM_BILL_OF_MATERIALS:BI1'
, BI1.ASSEMBLY_ITEM_ID
, BI1.ORGANIZATION_ID
, BI1.BILL_SEQUENCE_ID
, BI2.ALTERNATE_BOM_DESIGNATOR
, BI1.COMMON_ASSEMBLY_ITEM_ID
, BI1.COMMON_BILL_SEQUENCE_ID
, BI1.COMMON_ORGANIZATION_ID
, BI1.PROJECT_ID
, BI1.TASK_ID
, BI1.LAST_UPDATE_DATE UPDATED_ON
, BI1.LAST_UPDATED_BY UPDATED_BY
, BI1.CREATION_DATE CREATED_ON
, BI1.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL2
, HR_ALL_ORGANIZATION_UNITS AL1
, MTL_PARAMETERS PA1
, MTL_SYSTEM_ITEMS SY1
, BOM_BILL_OF_MATERIALS BI2
, MTL_PARAMETERS PA2
, MTL_SYSTEM_ITEMS SY2
, PA_TASKS TA
, PA_PROJECTS_ALL PR
, BOM_BILL_OF_MATERIALS BI1
WHERE BI1.ASSEMBLY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND BI1.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND BI1.ORGANIZATION_ID =PA1.ORGANIZATION_ID
AND BI1.ORGANIZATION_ID =AL1.ORGANIZATION_ID
AND BI1.COMMON_BILL_SEQUENCE_ID = BI2.BILL_SEQUENCE_ID(+)
AND BI1.COMMON_ORGANIZATION_ID = SY2.ORGANIZATION_ID(+)
AND BI1.COMMON_ASSEMBLY_ITEM_ID = SY2.INVENTORY_ITEM_ID(+)
AND BI1.COMMON_ORGANIZATION_ID = PA2.ORGANIZATION_ID(+)
AND BI1.ORGANIZATION_ID = AL2.ORGANIZATION_ID
AND BI1.PROJECT_ID = PR.PROJECT_ID(+)
AND BI1.TASK_ID = TA.TASK_ID(+)
AND BI1.ASSEMBLY_TYPE = 2
AND '_SEC:BI1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY