APPS.MSC_X_VMI_POREQ dependencies on MRP_AP_APPS_INSTANCES

Line 199: from MRP_AP_APPS_INSTANCES;

195: '@'||A2M_DBLINK),
196: INSTANCE_ID
197: into lv_dblink,
198: lv_instance_id
199: from MRP_AP_APPS_INSTANCES;
200: */
201: log_message(' destination database instance id/code/link = '
202: || p_instance_id
203: || '/' || p_instance_code

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 534: from MRP_AP_APPS_INSTANCES;

530: '@'||A2M_DBLINK),
531: INSTANCE_ID
532: into lv_dblink,
533: lv_instance_id
534: from MRP_AP_APPS_INSTANCES;
535:
536:
537: lv_sqlstmt:=
538: 'INSERT INTO PO_REQUISITIONS_INTERFACE_all'

Line 1028: from MRP_AP_APPS_INSTANCES;

1024: A2M_DBLINK
1025: into lv_dblink,
1026: lv_instance_id,
1027: lv_nulldblink
1028: from MRP_AP_APPS_INSTANCES;
1029: */
1030:
1031: log_message(' destination database instance id/code/link = '
1032: || p_instance_id

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;