APPS.INV_COPY_ORGANIZATION_REPORT dependencies on MTL_INTERORG_PARAMETERS

Line 1595: FROM MTL_INTERORG_PARAMETERS mip1

1591: , p_organization_id NUMBER
1592: )
1593: IS
1594: SELECT mp.ORGANIZATION_CODE
1595: FROM MTL_INTERORG_PARAMETERS mip1
1596: , MTL_PARAMETERS mp
1597: WHERE mip1.FROM_ORGANIZATION_ID = p_model_org_id
1598: AND mp.ORGANIZATION_ID = mip1.TO_ORGANIZATION_ID
1599: AND NOT EXISTS

Line 1601: FROM MTL_INTERORG_PARAMETERS mip2

1597: WHERE mip1.FROM_ORGANIZATION_ID = p_model_org_id
1598: AND mp.ORGANIZATION_ID = mip1.TO_ORGANIZATION_ID
1599: AND NOT EXISTS
1600: ( SELECT 'x'
1601: FROM MTL_INTERORG_PARAMETERS mip2
1602: WHERE mip2.FROM_ORGANIZATION_ID = p_organization_id
1603: AND mip2.TO_ORGANIZATION_ID = mip1.TO_ORGANIZATION_ID
1604: );
1605:

Line 1611: FROM MTL_INTERORG_PARAMETERS mip1

1607: , p_organization_id NUMBER
1608: )
1609: IS
1610: SELECT mp.ORGANIZATION_CODE
1611: FROM MTL_INTERORG_PARAMETERS mip1
1612: , MTL_PARAMETERS mp
1613: WHERE mip1.TO_ORGANIZATION_ID = p_model_org_id
1614: AND mp.ORGANIZATION_ID = mip1.FROM_ORGANIZATION_ID
1615: AND NOT EXISTS

Line 1617: FROM MTL_INTERORG_PARAMETERS mip2

1613: WHERE mip1.TO_ORGANIZATION_ID = p_model_org_id
1614: AND mp.ORGANIZATION_ID = mip1.FROM_ORGANIZATION_ID
1615: AND NOT EXISTS
1616: ( SELECT 'x'
1617: FROM MTL_INTERORG_PARAMETERS mip2
1618: WHERE mip2.TO_ORGANIZATION_ID = p_organization_id
1619: AND mip2.FROM_ORGANIZATION_ID = mip1.FROM_ORGANIZATION_ID
1620: );
1621:

Line 1625: FROM MTL_INTERORG_PARAMETERS mip

1621:
1622: CURSOR l_cnt_csr1 ( p_org_id NUMBER )
1623: IS
1624: SELECT COUNT(mip.TO_ORGANIZATION_ID)
1625: FROM MTL_INTERORG_PARAMETERS mip
1626: WHERE mip.FROM_ORGANIZATION_ID = p_org_id;
1627:
1628: CURSOR l_cnt_csr2 ( p_org_id NUMBER )
1629: IS

Line 1631: FROM MTL_INTERORG_PARAMETERS mip

1627:
1628: CURSOR l_cnt_csr2 ( p_org_id NUMBER )
1629: IS
1630: SELECT COUNT(mip.FROM_ORGANIZATION_ID)
1631: FROM MTL_INTERORG_PARAMETERS mip
1632: WHERE mip.TO_ORGANIZATION_ID = p_org_id;
1633:
1634: BEGIN
1635: