[Home] [Help]
490: IS
491: SELECT
492: bic.component_sequence_id
493: FROM
494: bom_inventory_components bic,
495: mtl_system_items_kfv it
496: WHERE
497: bic.bill_sequence_id = p_from_sequence_id
498: AND bic.component_item_id = it.inventory_item_id
768: IS
769: SELECT
770: bic.component_sequence_id
771: FROM
772: bom_inventory_components bic,
773: mtl_system_items_kfv it
774: WHERE
775: bic.bill_sequence_id = p_from_sequence_id
776: AND bic.component_item_id = it.inventory_item_id
1043: SELECT
1044: msi.concatenated_segments component_item_name,
1045: bic.component_item_id,
1046: bic.operation_seq_num
1047: FROM bom_inventory_components bic,
1048: mtl_system_items_kfv msi
1049: WHERE bic.bill_sequence_id = p_from_sequence_id
1050: AND bic.component_item_id = msi.inventory_item_id
1051: AND bic.component_item_id <> p_to_item_id
1217: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_from_end_item_unit_number) new_from_end_item_unit_number
1218: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.new_routing_revision) new_routing_revision
1219: ,DECODE(p_new_comp_item ,NULL ,NULL ,p_new_comp_item.return_status) return_status
1220: FROM
1221: bom_inventory_components bic,
1222: mtl_system_items_kfv it
1223: WHERE
1224: bic.component_item_id = it.inventory_item_id AND
1225: it.organization_id = p_reference_org_id AND
2271:
2272: --This cursor for redlining of BOM Components.
2273: Cursor c_component(p_rev_item_id NUMBER, p_component_item_id NUMBER, p_bill_sequence_id NUMBER) IS
2274: SELECT bic.effectivity_date, bic.operation_seq_num, bic.from_end_item_unit_number
2275: FROM bom_inventory_components bic
2276: ,eng_revised_items eri
2277: WHERE eri.revised_item_id = p_rev_item_id
2278: AND eri.organization_id = p_organization_id
2279: AND eri.bill_sequence_id = p_bill_sequence_id
2281: AND bic.operation_seq_num = p_op_sequence_number
2282: AND bic.bill_sequence_id = eri.bill_sequence_id
2283: AND bic.revised_item_sequence_id = eri.revised_item_sequence_id
2284: AND eri.implementation_date = (SELECT MAX(erj.implementation_date)
2285: FROM bom_inventory_components bcc
2286: ,eng_revised_items erj
2287: WHERE erj.revised_item_id = p_rev_item_id
2288: AND erj.organization_id = p_organization_id
2289: AND erj.bill_sequence_id = p_bill_sequence_id
3412: SELECT
3413: msi.concatenated_segments component_item_name ,
3414: bic.component_item_id
3415: FROM
3416: bom_inventory_components bic,
3417: mtl_system_items_kfv msi
3418: WHERE
3419: bic.bill_sequence_id = p_src_bill_sequence_id AND
3420: bic.component_item_id = msi.inventory_item_id AND
3481:
3482: SELECT
3483: msi.concatenated_segments sub_comp_item_name ,
3484: bsc.substitute_component_id
3485: FROM bom_inventory_components bic,
3486: bom_substitute_components bsc,
3487: mtl_system_items_kfv msi
3488: WHERE bic.bill_sequence_id = p_src_bill_sequence_id
3489: AND bic.component_sequence_id = bsc.component_sequence_id
4269: ,bsc.original_system_reference
4270: ,bsc.enforce_int_requirements
4271: ,bsc.program_id
4272: FROM
4273: bom_inventory_components bic
4274: ,eng_revised_items eri
4275: ,mtl_item_flexfields mif
4276: ,bom_substitute_components bsc
4277: WHERE
4305: ,brd.attribute14
4306: ,brd.attribute15
4307: ,brd.original_system_reference
4308: FROM
4309: bom_inventory_components bic
4310: ,eng_revised_items eri
4311: ,bom_reference_designators brd
4312: WHERE
4313: eri.change_id = p_change_id AND
4361: ,bic.suggested_vendor_name
4362: ,bic.unit_price
4363: ,bic.original_system_reference
4364: FROM
4365: bom_inventory_components bic
4366: ,eng_revised_items eri
4367: ,mtl_item_flexfields mif
4368: WHERE
4369: eri.change_id = p_change_id AND