APPS.CTO_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS_KFV

Line 870: from mtl_system_items_kfv msi,

866: -1
867: into v_missed_item,
868: v_missed_line_number,
869: v_order_number
870: from mtl_system_items_kfv msi,
871: bom_cto_order_lines bcol
872: where msi.organization_id = bcol.ship_from_org_id
873: and msi.inventory_item_id = bcol.inventory_item_id
874: and bcol.parent_ato_line_id = pLineId

Line 891: from mtl_system_items_kfv msi,

887: oeh.order_number
888: into v_missed_item,
889: v_missed_line_number,
890: v_order_number
891: from mtl_system_items_kfv msi,
892: oe_order_lines_all oel,
893: oe_order_headers_all oeh
894: ,bom_cto_order_lines bcol
895: where msi.organization_id = oel.ship_from_org_id

Line 930: from mtl_system_items_kfv

926: END IF;
927:
928: select substrb(concatenated_segments,1,50)
929: into l_model
930: from mtl_system_items_kfv
931: where organization_id = lNextRec.organization_id
932: and inventory_item_id = pModelId ;
933:
934:

Line 1691: from mtl_system_items_kfv

1687:
1688: if( v_bom_created = 0 and v_config_bom_exists = 0 ) then
1689:
1690: select concatenated_segments into v_model_item_name
1691: from mtl_system_items_kfv
1692: where inventory_item_id = pModelId
1693: and rownum = 1 ;
1694:
1695: