DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on BOM_BILL_OF_MATERIALS

Line 1099: FROM BOM_BILL_OF_MATERIALS

1095: and msi.replenish_to_order_flag = 'Y'
1096: and msi.bom_item_type = 4
1097: and not exists
1098: (SELECT COMMON_BILL_SEQUENCE_ID
1099: FROM BOM_BILL_OF_MATERIALS
1100: WHERE ASSEMBLY_ITEM_ID = wjsi_row.primary_item_id
1101: AND ORGANIZATION_ID = wjsi_row.organization_id
1102: AND nvl(ALTERNATE_BOM_DESIGNATOR,'none') =
1103: nvl(wjsi_row.alternate_bom_designator,'none')