DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 2586: FROM mtl_system_items_b_kfv msi

2582: THEN
2583: BEGIN
2584: SELECT msi.concatenated_segments
2585: INTO p_instance_header_tbl(tab_row).INVENTORY_ITEM_NAME
2586: FROM mtl_system_items_b_kfv msi
2587: ,csi_item_instances cii
2588: WHERE msi.inventory_item_id = p_instance_header_tbl(tab_row).inventory_item_id
2589: AND msi.organization_id = Nvl(p_instance_header_tbl(tab_row).vld_organization_id,cii.last_vld_organization_id)
2590: AND cii.instance_id = p_instance_header_tbl(tab_row).instance_id;

Line 2855: FROM mtl_system_items_b_kfv msi

2851: SELECT msi.concatenated_segments
2852: ,cii.instance_number
2853: INTO p_instance_header_tbl(tab_row).parent_asset_group
2854: ,p_instance_header_tbl(tab_row).parent_asset_number
2855: FROM mtl_system_items_b_kfv msi
2856: ,mtl_serial_numbers msn
2857: ,csi_item_instances cii
2858: ,mtl_object_genealogy mog
2859: WHERE msn.gen_object_id= mog.parent_object_id