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_REL_PLAN_PUB dependencies on MSC_WIP_JOB_DTLS_INTERFACE

Line 1963: DELETE MSC_WIP_JOB_DTLS_INTERFACE

1959:
1960: /* DELETE msc_wip_job_schedule_interface
1961: WHERE sr_instance_id= arg_org_instance;
1962:
1963: DELETE MSC_WIP_JOB_DTLS_INTERFACE
1964: WHERE sr_instance_id= arg_org_instance;
1965: */
1966: IF arg_loaded_reqs > 0 THEN
1967: DECLARE po_group_by_name VARCHAR2(10);

Line 2135: DELETE MSC_WIP_JOB_DTLS_INTERFACE

2131: DELETE msc_wip_job_schedule_interface
2132: WHERE sr_instance_id= arg_org_instance
2133: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2134:
2135: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2136: WHERE sr_instance_id= arg_org_instance
2137: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2138:
2139:

Line 2157: DELETE MSC_WIP_JOB_DTLS_INTERFACE

2153: DELETE msc_wip_job_schedule_interface
2154: WHERE sr_instance_id= arg_org_instance
2155: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2156:
2157: DELETE MSC_WIP_JOB_DTLS_INTERFACE
2158: WHERE sr_instance_id= arg_org_instance
2159: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
2160:
2161:

Line 4097: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4093: /* OPERATION NETWORKS */
4094:
4095:
4096: FORALL j IN 1..lv_job_count
4097: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4098: (last_update_date,
4099: last_updated_by,
4100: last_update_login,
4101: creation_date,

Line 4151: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4147:
4148: /* Operations */
4149:
4150: FORALL j IN 1..lv_job_count
4151: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4152: (last_update_date,
4153: last_updated_by,
4154: last_update_login,
4155: creation_date,

Line 4215: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4211: -- res.CUMMULATIVE_QUANTITY);
4212:
4213: /* Resources */
4214: FORALL j IN 1..lv_job_count
4215: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4216: (last_update_date,
4217: last_updated_by,
4218: last_update_login,
4219: creation_date,

Line 4321: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4317:
4318: /*Components*/
4319:
4320: FORALL j IN 1..lv_job_count
4321: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4322: (last_update_date,
4323: last_updated_by,
4324: last_update_login,
4325: creation_date,

Line 4419: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4415:
4416:
4417: /* Resource Usage */
4418: FORALL j IN 1..lv_job_count
4419: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4420: (last_update_date,
4421: last_updated_by,
4422: last_update_login,
4423: creation_date,

Line 4492: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4488: AND param.network_scheduling_method = 1);
4489:
4490: -- dsr begin: Operation Resource Instances
4491: FORALL j IN 1..lv_job_count
4492: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4493: ( last_update_date,
4494: last_updated_by,
4495: last_update_login,
4496: creation_date,

Line 4610: print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '

4606: AND param.network_scheduling_method = 1
4607: ;
4608:
4609:
4610: print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
4611: || SQL%ROWCOUNT
4612: );
4613:
4614: -- dsr: RESOURCE INSTANCE USAGES

Line 4617: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4613:
4614: -- dsr: RESOURCE INSTANCE USAGES
4615:
4616: FORALL j IN 1..lv_job_count
4617: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4618: ( last_update_date,
4619: last_updated_by,
4620: last_update_login,
4621: creation_date,

Line 4728: print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '

4724: AND param.sr_instance_id = s.sr_instance_id
4725: AND param.network_scheduling_method = 1
4726: ;
4727:
4728: print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
4729: || SQL%ROWCOUNT
4730: );
4731:
4732: -- dsr end

Line 5026: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5022: /* OPERATION NETWORKS */
5023:
5024:
5025: FORALL j IN 1..lv_resched_jobs
5026: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5027: (last_update_date,
5028: last_updated_by,
5029: last_update_login,
5030: creation_date,

Line 5082: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5078:
5079: /* Operations */
5080:
5081: FORALL j IN 1..lv_resched_jobs
5082: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5083: (last_update_date,
5084: last_updated_by,
5085: last_update_login,
5086: creation_date,

Line 5151: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5147: s.JOB_OP_SEQ_NUM);
5148:
5149: /* Resources */
5150: FORALL j IN 1..lv_resched_jobs
5151: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5152: (last_update_date,
5153: last_updated_by,
5154: last_update_login,
5155: creation_date,

Line 5259: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5255:
5256: /*Components*/
5257:
5258: FORALL j IN 1..lv_resched_jobs
5259: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5260: (last_update_date,
5261: last_updated_by,
5262: last_update_login,
5263: creation_date,

Line 5359: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5355:
5356:
5357: /* Resource Usage */
5358: FORALL j IN 1..lv_resched_jobs
5359: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5360: (last_update_date,
5361: last_updated_by,
5362: last_update_login,
5363: creation_date,

Line 5434: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5430:
5431: -- dsr begin: Operation Resource Instances
5432:
5433: FORALL j IN 1..lv_resched_jobs
5434: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5435: ( last_update_date,
5436: last_updated_by,
5437: last_update_login,
5438: creation_date,

Line 5554: print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '

5550: AND param.sr_instance_id = s.sr_instance_id
5551: AND param.network_scheduling_method = 1
5552: ;
5553:
5554: print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
5555: || sql%rowcount);
5556:
5557: FORALL j IN 1..lv_resched_jobs
5558: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

Line 5558: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5554: print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
5555: || sql%rowcount);
5556:
5557: FORALL j IN 1..lv_resched_jobs
5558: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5559: ( last_update_date,
5560: last_updated_by,
5561: last_update_login,
5562: creation_date,

Line 5672: print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '

5668: AND param.sr_instance_id = s.sr_instance_id
5669: AND param.network_scheduling_method = 1
5670: ;
5671:
5672: print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '
5673: || sql%rowcount);
5674:
5675:
5676: FORALL j IN 1..lv_resched_jobs

Line 6159: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6155: are the same as the planned date and quantity */
6156:
6157: /* OPERATIONS */
6158: FORALL j IN 1..lv_job_count
6159: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6160: (last_update_date,
6161: last_updated_by,
6162: last_update_login,
6163: creation_date,

Line 6267: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6263: than apply the CY on new_order_qty. This logic to use cummulative_qty is added to remove the calc. errors */
6264:
6265: /* OPERATION RESOURCES */
6266: FORALL j IN 1..lv_job_count
6267: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6268: ( last_update_date,
6269: last_updated_by,
6270: last_update_login,
6271: creation_date,

Line 6415: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6411: /* UPDATE EXISTING COMPONENTS *
6412: | We should set inventory_item_id_new to NULL |
6413: * */
6414: FORALL j IN 1..lv_job_count
6415: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6416: (last_update_date,
6417: last_updated_by,
6418: last_update_login,
6419: creation_date,

Line 6538: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6534: AND lv_agg_details(j) = 1;
6535:
6536: --Loading Co-products/by-products for OPM orgs
6537: FORALL j IN 1..lv_job_count
6538: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6539: (last_update_date,
6540: last_updated_by,
6541: last_update_login,
6542: creation_date,

Line 6642: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6638:
6639: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
6640: /* SUBSTITUTE EXISTING COMPONENTS */
6641: FORALL j IN 1..lv_job_count
6642: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6643: (last_update_date,
6644: last_updated_by,
6645: last_update_login,
6646: creation_date,

Line 6773: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6769:
6770:
6771: -- RESOURCE USAGE
6772: FORALL j IN 1..lv_job_count
6773: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6774: ( last_update_date,
6775: last_updated_by,
6776: last_update_login,
6777: creation_date,

Line 6904: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

6900: print_debug_info('OPERATION RESOURCE_INSTANCES');
6901: -- OPERATION RESOURCE_INSTANCES
6902:
6903: FORALL j IN 1..lv_job_count
6904: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
6905: ( last_update_date,
6906: last_updated_by,
6907: last_update_login,
6908: creation_date,

Line 7019: print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);

7015: AND lv_details_enabled(j)= 1
7016: AND lv_agg_details(j) = 1
7017: ;
7018:
7019: print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
7020: -- RESOURCE INSTANCE USAGES
7021: print_debug_info('RESOURCE INSTANCE USAGES ');
7022:
7023: FORALL j IN 1..lv_job_count

Line 7024: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7020: -- RESOURCE INSTANCE USAGES
7021: print_debug_info('RESOURCE INSTANCE USAGES ');
7022:
7023: FORALL j IN 1..lv_job_count
7024: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7025: ( last_update_date,
7026: last_updated_by,
7027: last_update_login,
7028: creation_date,

Line 7131: print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);

7127: AND lv_details_enabled(j)= 1
7128: AND lv_agg_details(j) = 1
7129: ;
7130:
7131: print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
7132:
7133: -- Resource Charges
7134: print_debug_info('Resource Charges ');
7135:

Line 7137: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7133: -- Resource Charges
7134: print_debug_info('Resource Charges ');
7135:
7136: FORALL j IN 1..lv_job_count
7137: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7138: ( last_update_date,
7139: last_updated_by,
7140: last_update_login,
7141: creation_date,

Line 7559: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7555: /* If it is not a drp plan then l_count = 1 by default so details will be released */
7556: IF l_count = 1 THEN /* Release details as well */
7557: -- OPERATIONS
7558: FORALL j IN 1..lv_job_count
7559: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7560: (last_update_date,
7561: last_updated_by,
7562: last_update_login,
7563: creation_date,

Line 7668: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7664: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
7665:
7666: -- OPERATION RESOURCES
7667: FORALL j IN 1..lv_job_count
7668: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7669: ( last_update_date,
7670: last_updated_by,
7671: last_update_login,
7672: creation_date,

Line 7798: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7794: /* UPDATE EXISTING COMPONENTS *
7795: | We should set inventory_item_id_new to NULL |
7796: * */
7797: FORALL j IN 1..lv_job_count
7798: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7799: (last_update_date,
7800: last_updated_by,
7801: last_update_login,
7802: creation_date,

Line 7917: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

7913:
7914: --Load Co-product/by-product component details
7915:
7916: FORALL j IN 1..lv_job_count
7917: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
7918: (last_update_date,
7919: last_updated_by,
7920: last_update_login,
7921: creation_date,

Line 8031: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8027: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
8028:
8029: -- RESOURCE USAGE
8030: FORALL j IN 1..lv_job_count
8031: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8032: ( last_update_date,
8033: last_updated_by,
8034: last_update_login,
8035: creation_date,

Line 8145: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8141: print_debug_info('OPERATION RESOURCE_INSTANCES');
8142: -- OPERATION RESOURCE_INSTANCES
8143:
8144: FORALL j IN 1..lv_job_count
8145: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8146: ( last_update_date,
8147: last_updated_by,
8148: last_update_login,
8149: creation_date,

Line 8268: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8264:
8265: -- RESOURCE INSTANCE USAGES
8266: print_debug_info('RESOURCE INSTANCE USAGES');
8267: FORALL j IN 1..lv_job_count
8268: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8269: ( last_update_date,
8270: last_updated_by,
8271: last_update_login,
8272: creation_date,

Line 8388: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

8384:
8385: print_debug_info('RESOURCE CHARGES');
8386:
8387: FORALL j IN 1..lv_job_count
8388: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
8389: ( last_update_date,
8390: last_updated_by,
8391: last_update_login,
8392: creation_date,