eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MSC_PURGE_LID dependencies on MSC_LOCAL_ID_DEMAND

Line 483: FROM msc_local_id_demand lid

479: lb_rowid RowidTab;
480:
481: CURSOR C1(p_instance_id NUMBER) IS
482: SELECT rowid
483: FROM msc_local_id_demand lid
484: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
485: AND lid.instance_id = p_instance_id
486: MINUS
487: SELECT distinct lid.rowid

Line 488: FROM msc_local_id_demand lid, msc_demands ms

484: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
485: AND lid.instance_id = p_instance_id
486: MINUS
487: SELECT distinct lid.rowid
488: FROM msc_local_id_demand lid, msc_demands ms
489: WHERE lid.instance_id = p_instance_id
490: AND lid.entity_name = 'DISPOSITION_ID_FCT'
491: AND ms.sales_order_line_id = lid.local_id
492: AND ms.plan_id = -1

Line 498: FROM msc_local_id_demand lid

494: AND ms.sr_instance_id = lid.instance_id;
495:
496: CURSOR C2(p_instance_id NUMBER) IS
497: SELECT rowid
498: FROM msc_local_id_demand lid
499: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
500: AND lid.instance_id = p_instance_id
501: MINUS
502: SELECT distinct lid.rowid

Line 503: FROM msc_local_id_demand lid, msc_demands ms

499: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
500: AND lid.instance_id = p_instance_id
501: MINUS
502: SELECT distinct lid.rowid
503: FROM msc_local_id_demand lid, msc_demands ms
504: WHERE lid.instance_id = p_instance_id
505: AND lid.entity_name = 'DISPOSITION_ID_MDS'
506: AND ms.disposition_id = lid.local_id
507: AND ms.origination_type = 8

Line 513: FROM msc_local_id_demand lid

509: AND ms.sr_instance_id = lid.instance_id;
510:
511: CURSOR C3(p_instance_id NUMBER) IS
512: SELECT rowid
513: FROM msc_local_id_demand lid
514: WHERE lid.entity_name ='SALES_ORDER_ID'
515: AND lid.instance_id = p_instance_id
516: MINUS
517: SELECT distinct lid.rowid

Line 518: FROM msc_local_id_demand lid, msc_sales_orders ms

514: WHERE lid.entity_name ='SALES_ORDER_ID'
515: AND lid.instance_id = p_instance_id
516: MINUS
517: SELECT distinct lid.rowid
518: FROM msc_local_id_demand lid, msc_sales_orders ms
519: WHERE lid.instance_id = p_instance_id
520: AND lid.entity_name = 'SALES_ORDER_ID'
521: AND ms.demand_source_header_id = lid.local_id
522: AND ms.sr_instance_id = lid.instance_id;

Line 526: FROM msc_local_id_demand lid

522: AND ms.sr_instance_id = lid.instance_id;
523:
524: CURSOR C4(p_instance_id NUMBER) IS
525: SELECT rowid
526: FROM msc_local_id_demand lid
527: WHERE lid.entity_name ='DEMAND_ID'
528: AND lid.instance_id = p_instance_id
529: MINUS
530: SELECT distinct lid.rowid

Line 531: FROM msc_local_id_demand lid, msc_sales_orders ms

527: WHERE lid.entity_name ='DEMAND_ID'
528: AND lid.instance_id = p_instance_id
529: MINUS
530: SELECT distinct lid.rowid
531: FROM msc_local_id_demand lid, msc_sales_orders ms
532: WHERE lid.instance_id = p_instance_id
533: AND lid.entity_name = 'DEMAND_ID'
534: AND ms.demand_id = lid.local_id
535: AND ms.sr_instance_id = lid.instance_id;

Line 944: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

940: DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', v_instance_id, NULL);
941:
942:
943: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
944: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
945: p_instance_id => v_instance_id ,
946: p_where_str => NULL );
947:
948: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_MDS',

Line 949: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

945: p_instance_id => v_instance_id ,
946: p_where_str => NULL );
947:
948: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_MDS',
949: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
950: p_instance_id => v_instance_id,
951: p_where_str => NULL );
952:
953: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',

Line 954: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

950: p_instance_id => v_instance_id,
951: p_where_str => NULL );
952:
953: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
954: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
955: p_instance_id => v_instance_id,
956: p_where_str => NULL );
957:
958: DELETE_LID_TABLE( p_entity_name => 'SALES_ORDER_ID',

Line 959: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

955: p_instance_id => v_instance_id,
956: p_where_str => NULL );
957:
958: DELETE_LID_TABLE( p_entity_name => 'SALES_ORDER_ID',
959: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
960: p_instance_id => v_instance_id,
961: p_where_str => NULL );
962:
963: DELETE_LID_TABLE( p_entity_name => 'DEMAND_ID',

Line 964: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

960: p_instance_id => v_instance_id,
961: p_where_str => NULL );
962:
963: DELETE_LID_TABLE( p_entity_name => 'DEMAND_ID',
964: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
965: p_instance_id => v_instance_id,
966: p_where_str => NULL );
967:
968: -----------------------DELETE Supply----------------------------

Line 1036: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT starts here --

1032: p_plan_id => NULL,
1033: p_sub_str => ' and trunc(REQUIREMENT_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1034:
1035:
1036: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT starts here --
1037:
1038: lv_task_start_time:= SYSDATE;
1039: lv_total := 0;
1040: v_sql_stmt := 01;

Line 1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT' );

1039: lv_total := 0;
1040: v_sql_stmt := 01;
1041:
1042:
1043: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT' );
1044:
1045:
1046: OPEN C1(v_instance_id);
1047:

Line 1054: DELETE FROM MSC_LOCAL_ID_DEMAND

1050: IF C1%ROWCOUNT > 0 THEN
1051:
1052: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1053:
1054: DELETE FROM MSC_LOCAL_ID_DEMAND
1055: WHERE ROWID = lb_rowid(j);
1056:
1057: lv_total := C1%ROWCOUNT;
1058:

Line 1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----

1068: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1069: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1070: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1071:
1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1073:
1074:
1075: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS starts here --
1076:

Line 1075: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS starts here --

1071:
1072: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1073:
1074:
1075: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS starts here --
1076:
1077: lv_task_start_time:= SYSDATE;
1078: lv_total := 0;
1079: v_sql_stmt := 02;

Line 1081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS');

1077: lv_task_start_time:= SYSDATE;
1078: lv_total := 0;
1079: v_sql_stmt := 02;
1080:
1081: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS');
1082:
1083:
1084: OPEN C2(v_instance_id);
1085:

Line 1092: DELETE FROM MSC_LOCAL_ID_DEMAND

1088: IF C2%ROWCOUNT > 0 THEN
1089:
1090: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1091:
1092: DELETE FROM MSC_LOCAL_ID_DEMAND
1093: WHERE ROWID = lb_rowid(j);
1094:
1095: lv_total := C2%ROWCOUNT;
1096:

Line 1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----

1107: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1108: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1109: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1110:
1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1112:
1113:
1114: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID starts here --
1115:

Line 1114: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID starts here --

1110:
1111: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1112:
1113:
1114: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID starts here --
1115:
1116: lv_task_start_time:= SYSDATE;
1117: lv_total := 0;
1118: v_sql_stmt := 03;

Line 1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID');

1116: lv_task_start_time:= SYSDATE;
1117: lv_total := 0;
1118: v_sql_stmt := 03;
1119:
1120: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID');
1121:
1122:
1123: OPEN C3(v_instance_id);
1124:

Line 1131: DELETE FROM MSC_LOCAL_ID_DEMAND

1127: IF C3%ROWCOUNT > 0 THEN
1128:
1129: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1130:
1131: DELETE FROM MSC_LOCAL_ID_DEMAND
1132: WHERE ROWID = lb_rowid(j);
1133:
1134: lv_total := C3%ROWCOUNT;
1135:

Line 1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----

1145: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1146: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1147: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1148:
1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1150:
1151:
1152: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID starts here --
1153:

Line 1152: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID starts here --

1148:
1149: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1150:
1151:
1152: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID starts here --
1153:
1154: lv_task_start_time:= SYSDATE;
1155: lv_total := 0;
1156: v_sql_stmt := 04;

Line 1158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID');

1154: lv_task_start_time:= SYSDATE;
1155: lv_total := 0;
1156: v_sql_stmt := 04;
1157:
1158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID');
1159:
1160:
1161: OPEN C4(v_instance_id);
1162:

Line 1169: DELETE FROM MSC_LOCAL_ID_DEMAND

1165: IF C4%ROWCOUNT > 0 THEN
1166:
1167: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1168:
1169: DELETE FROM MSC_LOCAL_ID_DEMAND
1170: WHERE ROWID = lb_rowid(j);
1171:
1172: lv_total := C4%ROWCOUNT;
1173:

Line 1186: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----

1182: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1183: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1184: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1185:
1186: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1187:
1188:
1189: END IF; -- p_demand_flag
1190: