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 465: FROM msc_local_id_demand lid

461: lb_rowid RowidTab;
462: lv_supplyId NUMBER;
463: CURSOR C1(p_instance_id NUMBER) IS
464: SELECT rowid
465: FROM msc_local_id_demand lid
466: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
467: AND lid.instance_id = p_instance_id
468: MINUS
469: SELECT distinct lid.rowid

Line 470: FROM msc_local_id_demand lid, msc_demands ms

466: WHERE lid.entity_name ='DISPOSITION_ID_FCT'
467: AND lid.instance_id = p_instance_id
468: MINUS
469: SELECT distinct lid.rowid
470: FROM msc_local_id_demand lid, msc_demands ms
471: WHERE lid.instance_id = p_instance_id
472: AND lid.entity_name = 'DISPOSITION_ID_FCT'
473: AND ms.sales_order_line_id = lid.local_id
474: AND ms.plan_id = -1

Line 480: FROM msc_local_id_demand lid

476: AND ms.sr_instance_id = lid.instance_id;
477:
478: CURSOR C2(p_instance_id NUMBER) IS
479: SELECT rowid
480: FROM msc_local_id_demand lid
481: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
482: AND lid.instance_id = p_instance_id
483: MINUS
484: SELECT distinct lid.rowid

Line 485: FROM msc_local_id_demand lid, msc_demands ms

481: WHERE lid.entity_name ='DISPOSITION_ID_MDS'
482: AND lid.instance_id = p_instance_id
483: MINUS
484: SELECT distinct lid.rowid
485: FROM msc_local_id_demand lid, msc_demands ms
486: WHERE lid.instance_id = p_instance_id
487: AND lid.entity_name = 'DISPOSITION_ID_MDS'
488: AND ms.disposition_id = lid.local_id
489: AND ms.origination_type = 8

Line 495: FROM msc_local_id_demand lid

491: AND ms.sr_instance_id = lid.instance_id;
492:
493: CURSOR C3(p_instance_id NUMBER) IS
494: SELECT rowid
495: FROM msc_local_id_demand lid
496: WHERE lid.entity_name ='SALES_ORDER_ID'
497: AND lid.instance_id = p_instance_id
498: MINUS
499: SELECT distinct lid.rowid

Line 500: FROM msc_local_id_demand lid, msc_sales_orders ms

496: WHERE lid.entity_name ='SALES_ORDER_ID'
497: AND lid.instance_id = p_instance_id
498: MINUS
499: SELECT distinct lid.rowid
500: FROM msc_local_id_demand lid, msc_sales_orders ms
501: WHERE lid.instance_id = p_instance_id
502: AND lid.entity_name = 'SALES_ORDER_ID'
503: AND ms.demand_source_header_id = lid.local_id
504: AND ms.sr_instance_id = lid.instance_id;

Line 508: FROM msc_local_id_demand lid

504: AND ms.sr_instance_id = lid.instance_id;
505:
506: CURSOR C4(p_instance_id NUMBER) IS
507: SELECT rowid
508: FROM msc_local_id_demand lid
509: WHERE lid.entity_name ='DEMAND_ID'
510: AND lid.instance_id = p_instance_id
511: MINUS
512: SELECT distinct lid.rowid

Line 513: FROM msc_local_id_demand lid, msc_sales_orders ms

509: WHERE lid.entity_name ='DEMAND_ID'
510: AND lid.instance_id = p_instance_id
511: MINUS
512: SELECT distinct lid.rowid
513: FROM msc_local_id_demand lid, msc_sales_orders ms
514: WHERE lid.instance_id = p_instance_id
515: AND lid.entity_name = 'DEMAND_ID'
516: AND ms.demand_id = lid.local_id
517: AND ms.sr_instance_id = lid.instance_id;

Line 931: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

927: DELETE_MSC_TABLE( 'MSC_SALES_ORDERS', v_instance_id, NULL);
928:
929:
930: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
931: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
932: p_instance_id => v_instance_id ,
933: p_where_str => NULL );
934:
935: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_MDS',

Line 936: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

932: p_instance_id => v_instance_id ,
933: p_where_str => NULL );
934:
935: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_MDS',
936: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
937: p_instance_id => v_instance_id,
938: p_where_str => NULL );
939:
940: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',

Line 941: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

937: p_instance_id => v_instance_id,
938: p_where_str => NULL );
939:
940: DELETE_LID_TABLE( p_entity_name => 'DISPOSITION_ID_FCT',
941: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
942: p_instance_id => v_instance_id,
943: p_where_str => NULL );
944:
945: DELETE_LID_TABLE( p_entity_name => 'SALES_ORDER_ID',

Line 946: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

942: p_instance_id => v_instance_id,
943: p_where_str => NULL );
944:
945: DELETE_LID_TABLE( p_entity_name => 'SALES_ORDER_ID',
946: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
947: p_instance_id => v_instance_id,
948: p_where_str => NULL );
949:
950: DELETE_LID_TABLE( p_entity_name => 'DEMAND_ID',

Line 951: p_lid_table => 'MSC_LOCAL_ID_DEMAND',

947: p_instance_id => v_instance_id,
948: p_where_str => NULL );
949:
950: DELETE_LID_TABLE( p_entity_name => 'DEMAND_ID',
951: p_lid_table => 'MSC_LOCAL_ID_DEMAND',
952: p_instance_id => v_instance_id,
953: p_where_str => NULL );
954:
955: -----------------------DELETE Supply----------------------------

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

1019: p_plan_id => NULL,
1020: p_sub_str => ' and trunc(REQUIREMENT_DATE) <= '||'trunc(to_date('||''''||p_date||''''||','||''''||'YYYY/MM/DD HH24:MI:SS'||''''||'))');
1021:
1022:
1023: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT starts here --
1024:
1025: lv_task_start_time:= SYSDATE;
1026: lv_total := 0;
1027: v_sql_stmt := 01;

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

1026: lv_total := 0;
1027: v_sql_stmt := 01;
1028:
1029:
1030: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT' );
1031:
1032:
1033: OPEN C1(v_instance_id);
1034:

Line 1041: DELETE FROM MSC_LOCAL_ID_DEMAND

1037: IF C1%ROWCOUNT > 0 THEN
1038:
1039: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1040:
1041: DELETE FROM MSC_LOCAL_ID_DEMAND
1042: WHERE ROWID = lb_rowid(j);
1043:
1044: lv_total := C1%ROWCOUNT;
1045:

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

1055: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1056: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1057: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1058:
1059: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1060:
1061:
1062: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS starts here --
1063:

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

1058:
1059: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_FCT ends here----
1060:
1061:
1062: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS starts here --
1063:
1064: lv_task_start_time:= SYSDATE;
1065: lv_total := 0;
1066: v_sql_stmt := 02;

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

1064: lv_task_start_time:= SYSDATE;
1065: lv_total := 0;
1066: v_sql_stmt := 02;
1067:
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS');
1069:
1070:
1071: OPEN C2(v_instance_id);
1072:

Line 1079: DELETE FROM MSC_LOCAL_ID_DEMAND

1075: IF C2%ROWCOUNT > 0 THEN
1076:
1077: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1078:
1079: DELETE FROM MSC_LOCAL_ID_DEMAND
1080: WHERE ROWID = lb_rowid(j);
1081:
1082: lv_total := C2%ROWCOUNT;
1083:

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

1094: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1095: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1096: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1097:
1098: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1099:
1100:
1101: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID starts here --
1102:

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

1097:
1098: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DISPOSITION_ID_MDS ends here----
1099:
1100:
1101: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID starts here --
1102:
1103: lv_task_start_time:= SYSDATE;
1104: lv_total := 0;
1105: v_sql_stmt := 03;

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

1103: lv_task_start_time:= SYSDATE;
1104: lv_total := 0;
1105: v_sql_stmt := 03;
1106:
1107: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID');
1108:
1109:
1110: OPEN C3(v_instance_id);
1111:

Line 1118: DELETE FROM MSC_LOCAL_ID_DEMAND

1114: IF C3%ROWCOUNT > 0 THEN
1115:
1116: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1117:
1118: DELETE FROM MSC_LOCAL_ID_DEMAND
1119: WHERE ROWID = lb_rowid(j);
1120:
1121: lv_total := C3%ROWCOUNT;
1122:

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

1132: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1133: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1134: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1135:
1136: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1137:
1138:
1139: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID starts here --
1140:

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

1135:
1136: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name SALES_ORDER_ID ends here----
1137:
1138:
1139: -- Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID starts here --
1140:
1141: lv_task_start_time:= SYSDATE;
1142: lv_total := 0;
1143: v_sql_stmt := 04;

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

1141: lv_task_start_time:= SYSDATE;
1142: lv_total := 0;
1143: v_sql_stmt := 04;
1144:
1145: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_DEBUG_1,'Delete from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID');
1146:
1147:
1148: OPEN C4(v_instance_id);
1149:

Line 1156: DELETE FROM MSC_LOCAL_ID_DEMAND

1152: IF C4%ROWCOUNT > 0 THEN
1153:
1154: FORALL j IN lb_rowid.FIRST..lb_rowid.LAST
1155:
1156: DELETE FROM MSC_LOCAL_ID_DEMAND
1157: WHERE ROWID = lb_rowid(j);
1158:
1159: lv_total := C4%ROWCOUNT;
1160:

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

1169: FND_MESSAGE.SET_NAME('MSC', 'MSC_ELAPSED_TIME');
1170: FND_MESSAGE.SET_TOKEN('ELAPSED_TIME',TO_CHAR(CEIL((SYSDATE- lv_task_start_time)*14400.0)/10));
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS,' '||FND_MESSAGE.GET);
1172:
1173: -- Deletion from MSC_LOCAL_ID_DEMAND for entity_name DEMAND_ID ends here ----
1174:
1175:
1176: END IF; -- p_demand_flag
1177: