View: BOMFV_MANUFACTURING_BOMS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.BOMFV_MANUFACTURING_BOMS

View Text

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
, PA2.ORGANIZATION_CODE COMMON_ORGANIZATION_CODE
, AL2.NAME COMMON_ORGANIZATION_NAME
, '_KF:INV:MSTK:SY2' "_KF:COMMON_BILL_ITEM_NAME"
, BI1.PENDING_FROM_ECN PENDING_FROM_ECO
, 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 PA_PROJECTS_ALL PR
, PA_TASKS TA
, HR_ALL_ORGANIZATION_UNITS AL2
, MTL_SYSTEM_ITEMS_B SY2
, MTL_PARAMETERS PA2
, BOM_BILL_OF_MATERIALS BI2
, MTL_SYSTEM_ITEMS_B SY1
, MTL_PARAMETERS PA1
, HR_ALL_ORGANIZATION_UNITS AL1
, 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 = 1
AND '_SEC:BI1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns