APPS.INVIDIT3 dependencies on BOM_INVENTORY_COMPONENTS

Line 1000: -- bom_inventory_components.

996:
997: -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
998:
999: -- Check if the item is a component with Check ATP = 1 (yes) in
1000: -- bom_inventory_components.
1001: -- If controlled at Item level, check in child orgs too
1002: -- Used to determine if atp_flag is updateable
1003: -- X_comp_atp will have either 0 or 1
1004:

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

1005: --3432253 atp check nolonger required...please refer to below mentioned bugs.
1006: --The below query is causing a performance problem and query result is not used.
1007: --Bug 1457730 : we do not need this validation after bugfix 1123857 in BOM
1008: /*
1009: select LEADING(BIC) INDEX(BIC BOM_INVENTORY_COMPONENTS_N1) USE_NL(BIC BOM)
1010: count(1)
1011: into X_comp_atp
1012: from bom_inventory_components bic, bom_bill_of_materials bom
1013: where bic.bill_sequence_id = bom.common_bill_sequence_id

Line 1012: from bom_inventory_components bic, bom_bill_of_materials bom

1008: /*
1009: select LEADING(BIC) INDEX(BIC BOM_INVENTORY_COMPONENTS_N1) USE_NL(BIC BOM)
1010: count(1)
1011: into X_comp_atp
1012: from bom_inventory_components bic, bom_bill_of_materials bom
1013: where bic.bill_sequence_id = bom.common_bill_sequence_id
1014: and bic.component_item_id = p_item_id
1015: and bic.check_atp = 1
1016: and (bom.organization_id in

Line 1082: bom_inventory_components inv,

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

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

1091: and rownum = 1;
1092:
1093: end if;
1094:
1095: -- Check if there are rows in bom_inventory_components
1096: -- bom_item_type is always controlled at Item level, so check all child orgs
1097: -- Used to determine if bom_item_type is updateable
1098: -- Local variable bom_inventory will have either 0 or 1
1099:

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

1098: -- Local variable bom_inventory will have either 0 or 1
1099:
1100: if (bom_row_exists <> 1 and bom_substitute <> 1) then
1101:
1102: select /*+ LEADING(INV) INDEX(INV BOM_INVENTORY_COMPONENTS_N1) USE_NL(INV BOM) */
1103: count(1)
1104: into bom_inventory
1105: from bom_inventory_components inv, bom_bill_of_materials bom
1106: where inv.component_item_id = p_item_id

Line 1105: from bom_inventory_components inv, bom_bill_of_materials bom

1101:
1102: select /*+ LEADING(INV) INDEX(INV BOM_INVENTORY_COMPONENTS_N1) USE_NL(INV BOM) */
1103: count(1)
1104: into bom_inventory
1105: from bom_inventory_components inv, bom_bill_of_materials bom
1106: where inv.component_item_id = p_item_id
1107: and inv.bill_sequence_id=bom.bill_sequence_id
1108: and bom.organization_id in
1109: (select organization_id