DBA Data[Home] [Help]

APPS.MSC_X_VMI_POREQ dependencies on MRP_AP_APPS_INSTANCES_ALL

Line 212: from MRP_AP_APPS_INSTANCES_ALL

208: select DECODE( A2M_DBLINK, NULL, ' ','@'||A2M_DBLINK),
209: INSTANCE_ID
210: into lv_dblink,
211: lv_instance_id
212: from MRP_AP_APPS_INSTANCES_ALL
213: where instance_id = p_instance_id
214: and instance_code = p_instance_code
215: and nvl(a2m_dblink,'NULL_DBLINK') = nvl(p_dblink,'NULL_DBLINK')
216: and ALLOW_RELEASE_FLAG=1;

Line 1044: from MRP_AP_APPS_INSTANCES_ALL

1040: , A2M_DBLINK
1041: into lv_dblink,
1042: lv_instance_id
1043: , lv_nulldblink
1044: from MRP_AP_APPS_INSTANCES_ALL
1045: where instance_id = p_instance_id
1046: and instance_code = p_instance_code
1047: and nvl(a2m_dblink,'NULL_DBLINK') = nvl(p_a2m_dblink,'NULL_DBLINK')
1048: and ALLOW_RELEASE_FLAG=1;