APPS.MRP_AP_REL_PLAN_PUB dependencies on MRP_AP_APPS_INSTANCES_ALL

Line 1829: from MRP_AP_APPS_INSTANCES_ALL

1825: '@'||A2M_DBLINK),
1826: INSTANCE_ID
1827: into lv_dblink,
1828: lv_instance_id
1829: from MRP_AP_APPS_INSTANCES_ALL
1830: where instance_id = v_instance_id
1831: and instance_code = v_instance_code
1832: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
1833: and ALLOW_RELEASE_FLAG=1;

Line 2138: from MRP_AP_APPS_INSTANCES_ALL

2134: '@'||A2M_DBLINK),
2135: INSTANCE_ID
2136: into lv_dblink,
2137: lv_instance_id
2138: from MRP_AP_APPS_INSTANCES_ALL
2139: where instance_id = v_instance_id
2140: and instance_code = v_instance_code
2141: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2142: and ALLOW_RELEASE_FLAG=1;

Line 2528: from MRP_AP_APPS_INSTANCES_ALL

2524: '@'||A2M_DBLINK),
2525: INSTANCE_ID
2526: into lv_dblink,
2527: lv_instance_id
2528: from MRP_AP_APPS_INSTANCES_ALL
2529: where instance_id = v_instance_id
2530: and instance_code = v_instance_code
2531: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2532: and ALLOW_RELEASE_FLAG=1;

Line 2636: from MRP_AP_APPS_INSTANCES_ALL

2632: '@'||A2M_DBLINK),
2633: INSTANCE_ID
2634: into lv_dblink,
2635: lv_instance_id
2636: from MRP_AP_APPS_INSTANCES_ALL
2637: where instance_id = v_instance_id
2638: and instance_code = v_instance_code
2639: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2640: and ALLOW_RELEASE_FLAG=1;

Line 2706: from MRP_AP_APPS_INSTANCES_ALL

2702: '@'||A2M_DBLINK),
2703: INSTANCE_ID
2704: into lv_dblink,
2705: lv_instance_id
2706: from MRP_AP_APPS_INSTANCES_ALL
2707: where instance_id = v_instance_id
2708: and instance_code = v_instance_code
2709: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2710: and ALLOW_RELEASE_FLAG=1;

Line 2809: from MRP_AP_APPS_INSTANCES_ALL

2805: '@'||A2M_DBLINK),
2806: INSTANCE_ID
2807: into lv_dblink,
2808: lv_instance_id
2809: from MRP_AP_APPS_INSTANCES_ALL
2810: where instance_id = v_instance_id
2811: and instance_code = v_instance_code
2812: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2813: and ALLOW_RELEASE_FLAG=1;

Line 3106: from MRP_AP_APPS_INSTANCES_ALL

3102: '@'||A2M_DBLINK),
3103: INSTANCE_ID
3104: into lv_dblink,
3105: lv_instance_id
3106: from MRP_AP_APPS_INSTANCES_ALL
3107: where instance_id = v_instance_id
3108: and instance_code = v_instance_code
3109: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
3110: and ALLOW_RELEASE_FLAG=1;

Line 4546: from MRP_AP_APPS_INSTANCES_ALL

4542: '@'||A2M_DBLINK),
4543: INSTANCE_ID
4544: into lv_dblink,
4545: lv_instance_id
4546: from MRP_AP_APPS_INSTANCES_ALL
4547: where instance_id = v_instance_id
4548: and instance_code = v_instance_code
4549: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
4550: and ALLOW_RELEASE_FLAG=1;