[Home] [Help]
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
1036: -- X_bom_exists will have either 0 or 1
1037:
1038: /*select count(*) into bom_row_exists from dual
1039: where exists
1040: ( select 'x' from bom_bill_of_materials bom
1041: where bom.assembly_item_id = p_item_id
1042: and bom.organization_id in
1043: ( select organization_id
1044: from mtl_parameters
1050: -- as part of fix for bug#3451941.
1051: IF X_bom_exists IS NOT NULL THEN
1052: select count(*) into bom_row_exists from dual
1053: where exists
1054: ( select 'x' from bom_bill_of_materials bom
1055: where bom.assembly_item_id = p_item_id
1056: and bom.organization_id in
1057: ( select organization_id
1058: from mtl_parameters
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
1087: and bom.organization_id in
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