[Home] [Help]
1082: /*
1083: select LEADING(BIC) INDEX(BIC BOM_INVENTORY_COMPONENTS_N1) USE_NL(BIC BOM)
1084: count(1)
1085: into X_comp_atp
1086: from bom_inventory_components bic, bom_bill_of_materials bom
1087: where bic.bill_sequence_id = bom.common_bill_sequence_id
1088: and bic.component_item_id = p_item_id
1089: and bic.check_atp = 1
1090: and (bom.organization_id in
1110: -- X_bom_exists will have either 0 or 1
1111:
1112: /*select count(*) into bom_row_exists from dual
1113: where exists
1114: ( select 'x' from bom_bill_of_materials bom
1115: where bom.assembly_item_id = p_item_id
1116: and bom.organization_id in
1117: ( select organization_id
1118: from mtl_parameters
1124: -- as part of fix for bug#3451941.
1125: IF X_bom_exists IS NOT NULL THEN
1126: select count(*) into bom_row_exists from dual
1127: where exists
1128: ( select 'x' from bom_bill_of_materials bom
1129: where bom.assembly_item_id = p_item_id
1130: and bom.organization_id in
1131: ( select organization_id
1132: from mtl_parameters
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
1160: and inv.bill_sequence_id = bom.bill_sequence_id
1161: and bom.organization_id in
1175:
1176: select /*+ LEADING(INV) INDEX(INV BOM_INVENTORY_COMPONENTS_N1) USE_NL(INV BOM) */
1177: count(1)
1178: into bom_inventory
1179: from bom_inventory_components inv, bom_bill_of_materials bom
1180: where inv.component_item_id = p_item_id
1181: and inv.bill_sequence_id=bom.bill_sequence_id
1182: and exists (select count(1)
1183: from MTL_PARAMETERS