DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PVT dependencies on MTL_OBJECT_GENEALOGY

Line 2858: ,mtl_object_genealogy mog

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
2860: AND mog.object_id = l_gen_object_id
2861: AND mog.genealogy_type =5
2862: AND (sysdate BETWEEN mog.start_date_active AND nvl(mog.end_date_active,sysdate))