DBA Data[Home] [Help]

APPS.INVIDIT3 dependencies on BOM_SUBSTITUTE_COMPONENTS

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

1142: END IF;
1143:
1144: X_bom_exists := bom_row_exists;
1145:
1146: -- Check if there are rows in bom_substitute_components
1147: -- bom_item_type is always controlled at Item level, so check all child orgs
1148: -- Used to determine if bom_item_type is updateable
1149: -- Local variable bom_substitute will have either 0 or 1
1150: IF X_bom_item IS NOT NULL THEN

Line 1155: from bom_substitute_components sub,

1151: if (bom_row_exists <> 1) then
1152:
1153: select count(1)
1154: into bom_substitute
1155: from bom_substitute_components sub,
1156: bom_inventory_components inv,
1157: bom_bill_of_materials bom
1158: where sub.substitute_component_id = p_item_id
1159: and sub.component_sequence_id = inv.component_sequence_id