View: BOMFV_BILL_OF_MATERIALS

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

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
, 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
, '_LA:BI1.ASSEMBLY_TYPE:MFG_LOOKUPS:ECG_BOM_COMP_SEL:MEANING'
, '_DF:BOM:BOM_BILL_OF_MATERIALS:BI1'
, BI2.ALTERNATE_BOM_DESIGNATOR
, BI1.ASSEMBLY_ITEM_ID
, BI1.ORGANIZATION_ID
, BI1.BILL_SEQUENCE_ID
, 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 '_SEC:BI1.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns