APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_RTG_ITEM_REVISIONS

Line 3290: FROM MTL_RTG_ITEM_REVISIONS rev

3286: , p_organization_id NUMBER
3287: )
3288: IS
3289: SELECT kfv.CONCATENATED_SEGMENTS
3290: FROM MTL_RTG_ITEM_REVISIONS rev
3291: , MTL_SYSTEM_ITEMS_KFV kfv
3292: WHERE kfv.ORGANIZATION_ID = rev.ORGANIZATION_ID
3293: AND kfv.INVENTORY_ITEM_ID = rev.INVENTORY_ITEM_ID
3294: AND rev.ORGANIZATION_ID = p_model_org_id

Line 3297: FROM MTL_RTG_ITEM_REVISIONS rev1

3293: AND kfv.INVENTORY_ITEM_ID = rev.INVENTORY_ITEM_ID
3294: AND rev.ORGANIZATION_ID = p_model_org_id
3295: AND NOT EXISTS
3296: ( SELECT 'x'
3297: FROM MTL_RTG_ITEM_REVISIONS rev1
3298: WHERE rev1.ORGANIZATION_ID = p_organization_id
3299: AND rev1.INVENTORY_ITEM_ID = rev.INVENTORY_ITEM_ID
3300: AND rev1.PROCESS_REVISION = rev.PROCESS_REVISION
3301: );

Line 3306: FROM MTL_RTG_ITEM_REVISIONS rev

3302:
3303: CURSOR l_child_4_cnt ( p_org_id NUMBER )
3304: IS
3305: SELECT COUNT(rev.PROCESS_REVISION)
3306: FROM MTL_RTG_ITEM_REVISIONS rev
3307: WHERE rev.ORGANIZATION_ID = p_org_id;
3308:
3309: BEGIN
3310: