DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on BOM_SUBSTITUTE_COMPONENTS

Line 1072: -- Check if there are rows in bom_substitute_components

1068: END IF;
1069:
1070: X_bom_exists := bom_row_exists;
1071:
1072: -- Check if there are rows in bom_substitute_components
1073: -- bom_item_type is always controlled at Item level, so check all child orgs
1074: -- Used to determine if bom_item_type is updateable
1075: -- Local variable bom_substitute will have either 0 or 1
1076: IF X_bom_item IS NOT NULL THEN

Line 1081: from bom_substitute_components sub,

1077: if (bom_row_exists <> 1) then
1078:
1079: select count(1)
1080: into bom_substitute
1081: from bom_substitute_components sub,
1082: bom_inventory_components inv,
1083: bom_bill_of_materials bom
1084: where sub.substitute_component_id = p_item_id
1085: and sub.component_sequence_id = inv.component_sequence_id