APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_ITEM_REVISIONS_B

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: