DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_ITEM_REVISIONS

Line 2429: FROM MTL_ITEM_REVISIONS rev1

2425: , p_organization_id NUMBER
2426: )
2427: IS
2428: SELECT kfv.CONCATENATED_SEGMENTS||': '||rev1.REVISION
2429: FROM MTL_ITEM_REVISIONS rev1
2430: , MTL_SYSTEM_ITEMS_KFV kfv
2431: WHERE kfv.ORGANIZATION_ID = rev1.ORGANIZATION_ID
2432: AND kfv.INVENTORY_ITEM_ID = rev1.INVENTORY_ITEM_ID
2433: AND rev1.ORGANIZATION_ID = p_model_org_id

Line 2436: FROM MTL_ITEM_REVISIONS rev2

2432: AND kfv.INVENTORY_ITEM_ID = rev1.INVENTORY_ITEM_ID
2433: AND rev1.ORGANIZATION_ID = p_model_org_id
2434: AND NOT EXISTS
2435: ( SELECT 'x'
2436: FROM MTL_ITEM_REVISIONS rev2
2437: WHERE rev2.REVISION = rev1.REVISION
2438: AND rev2.INVENTORY_ITEM_ID = rev1.INVENTORY_ITEM_ID
2439: AND rev2.ORGANIZATION_ID = p_organization_id
2440: );

Line 2442: -- Bug : 3637921 Modified the MTL_ITEM_REVISIONS view usage with

2438: AND rev2.INVENTORY_ITEM_ID = rev1.INVENTORY_ITEM_ID
2439: AND rev2.ORGANIZATION_ID = p_organization_id
2440: );
2441:
2442: -- Bug : 3637921 Modified the MTL_ITEM_REVISIONS view usage with
2443: -- with the MTL_ITEM_REVISIONS_B base table.
2444: CURSOR l_cnt_csr ( p_org_id NUMBER )
2445: IS
2446: SELECT COUNT(rev.REVISION_ID)

Line 2443: -- with the MTL_ITEM_REVISIONS_B base table.

2439: AND rev2.ORGANIZATION_ID = p_organization_id
2440: );
2441:
2442: -- Bug : 3637921 Modified the MTL_ITEM_REVISIONS view usage with
2443: -- with the MTL_ITEM_REVISIONS_B base table.
2444: CURSOR l_cnt_csr ( p_org_id NUMBER )
2445: IS
2446: SELECT COUNT(rev.REVISION_ID)
2447: FROM MTL_ITEM_REVISIONS_B rev

Line 2447: FROM MTL_ITEM_REVISIONS_B rev

2443: -- with the MTL_ITEM_REVISIONS_B base table.
2444: CURSOR l_cnt_csr ( p_org_id NUMBER )
2445: IS
2446: SELECT COUNT(rev.REVISION_ID)
2447: FROM MTL_ITEM_REVISIONS_B rev
2448: WHERE rev.ORGANIZATION_ID=p_org_id;
2449:
2450: BEGIN
2451: