APPS.INVIDIT3 dependencies on BOM_INVENTORY_COMPONENTS

Line 1074: -- bom_inventory_components.

1070:
1071: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1072:
1073: -- Check if the item is a component with Check ATP = 1 (yes) in
1074: -- bom_inventory_components.
1075: -- If controlled at Item level, check in child orgs too
1076: -- Used to determine if atp_flag is updateable
1077: -- X_comp_atp will have either 0 or 1
1078:

Line 1083: select LEADING(BIC) INDEX(BIC BOM_INVENTORY_COMPONENTS_N1) USE_NL(BIC BOM)

1079: --3432253 atp check nolonger required...please refer to below mentioned bugs.
1080: --The below query is causing a performance problem and query result is not used.
1081: --Bug 1457730 : we do not need this validation after bugfix 1123857 in BOM
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

Line 1086: from bom_inventory_components bic, bom_bill_of_materials bom

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

Line 1156: bom_inventory_components inv,

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
1160: and inv.bill_sequence_id = bom.bill_sequence_id

Line 1169: -- Check if there are rows in bom_inventory_components

1165: and rownum = 1;
1166:
1167: end if;
1168:
1169: -- Check if there are rows in bom_inventory_components
1170: -- bom_item_type is always controlled at Item level, so check all child orgs
1171: -- Used to determine if bom_item_type is updateable
1172: -- Local variable bom_inventory will have either 0 or 1
1173:

Line 1176: select /*+ LEADING(INV) INDEX(INV BOM_INVENTORY_COMPONENTS_N1) USE_NL(INV BOM) */

1172: -- Local variable bom_inventory will have either 0 or 1
1173:
1174: if (bom_row_exists <> 1 and bom_substitute <> 1) then
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

Line 1179: from bom_inventory_components inv, bom_bill_of_materials bom

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