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

Line 667: DELETE MSC_WIP_JOB_DTLS_INTERFACE

663:
664: /* DELETE msc_wip_job_schedule_interface
665: WHERE sr_instance_id= arg_org_instance;
666:
667: DELETE MSC_WIP_JOB_DTLS_INTERFACE
668: WHERE sr_instance_id= arg_org_instance;
669: */
670: IF arg_loaded_reqs > 0 THEN
671: DECLARE po_group_by_name VARCHAR2(10);

Line 810: DELETE MSC_WIP_JOB_DTLS_INTERFACE

806: DELETE msc_wip_job_schedule_interface
807: WHERE sr_instance_id= arg_org_instance
808: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
809:
810: DELETE MSC_WIP_JOB_DTLS_INTERFACE
811: WHERE sr_instance_id= arg_org_instance
812: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
813:
814: DELETE MSC_PO_REQUISITIONS_INTERFACE

Line 833: DELETE MSC_WIP_JOB_DTLS_INTERFACE

829: DELETE msc_wip_job_schedule_interface
830: WHERE sr_instance_id= arg_org_instance
831: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
832:
833: DELETE MSC_WIP_JOB_DTLS_INTERFACE
834: WHERE sr_instance_id= arg_org_instance
835: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
836:
837: DELETE MSC_PO_REQUISITIONS_INTERFACE

Line 1124: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1120: /* OPERATION NETWORKS */
1121:
1122:
1123: FORALL j IN 1..lv_job_count
1124: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1125: (last_update_date,
1126: last_updated_by,
1127: last_update_login,
1128: creation_date,

Line 1178: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1174:
1175: /* Operations */
1176:
1177: FORALL j IN 1..lv_job_count
1178: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1179: (last_update_date,
1180: last_updated_by,
1181: last_update_login,
1182: creation_date,

Line 1241: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1237: s.sr_instance_id);
1238:
1239: /* Resources */
1240: FORALL j IN 1..lv_job_count
1241: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1242: (last_update_date,
1243: last_updated_by,
1244: last_update_login,
1245: creation_date,

Line 1365: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1361:
1362: /*Components*/
1363:
1364: FORALL j IN 1..lv_job_count
1365: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1366: (last_update_date,
1367: last_updated_by,
1368: last_update_login,
1369: creation_date,

Line 1464: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1460:
1461:
1462: /* Resource Usage */
1463: FORALL j IN 1..lv_job_count
1464: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1465: (last_update_date,
1466: last_updated_by,
1467: last_update_login,
1468: creation_date,

Line 1532: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1528: AND s.release_status = 1);
1529:
1530: -- dsr begin: Operation Resource Instances
1531: FORALL j IN 1..lv_job_count
1532: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1533: ( last_update_date,
1534: last_updated_by,
1535: last_update_login,
1536: creation_date,

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

1634: AND param.network_scheduling_method = 1
1635: AND s.release_status = 1;
1636:
1637:
1638: -- print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
1639: -- || SQL%ROWCOUNT
1640: -- );
1641:
1642: -- dsr: RESOURCE INSTANCE USAGES

Line 1645: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1641:
1642: -- dsr: RESOURCE INSTANCE USAGES
1643:
1644: FORALL j IN 1..lv_job_count
1645: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1646: ( last_update_date,
1647: last_updated_by,
1648: last_update_login,
1649: creation_date,

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

1741: AND param.network_scheduling_method = 1
1742: AND s.release_status = 1
1743: ;
1744:
1745: -- print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
1746: -- || SQL%ROWCOUNT
1747: -- );
1748:
1749: -- dsr end

Line 1990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1986: /* OPERATION NETWORKS */
1987:
1988:
1989: FORALL j IN 1..lv_resched_jobs
1990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1991: (last_update_date,
1992: last_updated_by,
1993: last_update_login,
1994: creation_date,

Line 2047: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2043:
2044: /* Operations */
2045:
2046: FORALL j IN 1..lv_resched_jobs
2047: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2048: (last_update_date,
2049: last_updated_by,
2050: last_update_login,
2051: creation_date,

Line 2116: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2112: s.JOB_OP_SEQ_NUM);
2113:
2114: /* Resources */
2115: FORALL j IN 1..lv_resched_jobs
2116: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2117: (last_update_date,
2118: last_updated_by,
2119: last_update_login,
2120: creation_date,

Line 2243: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2239:
2240: /*Components*/
2241:
2242: FORALL j IN 1..lv_resched_jobs
2243: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2244: (last_update_date,
2245: last_updated_by,
2246: last_update_login,
2247: creation_date,

Line 2345: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2341:
2342:
2343: /* Resource Usage */
2344: FORALL j IN 1..lv_resched_jobs
2345: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2346: (last_update_date,
2347: last_updated_by,
2348: last_update_login,
2349: creation_date,

Line 2416: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2412: AND s.release_status = 1);
2413: -- dsr begin: Operation Resource Instances
2414:
2415: FORALL j IN 1..lv_resched_jobs
2416: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2417: ( last_update_date,
2418: last_updated_by,
2419: last_update_login,
2420: creation_date,

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

2520: AND param.network_scheduling_method = 1
2521: AND s.release_status = 1
2522: ;
2523:
2524: -- print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
2525: -- || sql%rowcount);
2526:
2527: FORALL j IN 1..lv_resched_jobs
2528: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

Line 2528: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2524: -- print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
2525: -- || sql%rowcount);
2526:
2527: FORALL j IN 1..lv_resched_jobs
2528: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2529: ( last_update_date,
2530: last_updated_by,
2531: last_update_login,
2532: creation_date,

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

2626: AND param.network_scheduling_method = 1
2627: AND s.release_status = 1
2628: ;
2629:
2630: -- print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '
2631: -- || sql%rowcount);
2632:
2633: -- dsr end
2634: RETURN lv_resched_jobs;

Line 2920: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2916: are the same as the planned date and quantity */
2917:
2918: /* OPERATIONS */
2919: FORALL j IN 1..lv_job_count
2920: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2921: (last_update_date,
2922: last_updated_by,
2923: last_update_login,
2924: creation_date,

Line 3023: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3019: than apply the CY on new_order_qty. This logic to use cummulative_qty is added to remove the calc. errors */
3020:
3021: /* OPERATION RESOURCES */
3022: FORALL j IN 1..lv_job_count
3023: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3024: ( last_update_date,
3025: last_updated_by,
3026: last_update_login,
3027: creation_date,

Line 3153: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3149: /* UPDATE EXISTING COMPONENTS *
3150: | We should set inventory_item_id_new to NULL |
3151: * */
3152: FORALL j IN 1..lv_job_count
3153: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3154: (last_update_date,
3155: last_updated_by,
3156: last_update_login,
3157: creation_date,

Line 3250: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3246: AND s.release_status = 1;
3247:
3248: --Loading Co-products/by-products for OPM orgs
3249: FORALL j IN 1..lv_job_count
3250: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3251: (last_update_date,
3252: last_updated_by,
3253: last_update_login,
3254: creation_date,

Line 3337: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3333:
3334: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
3335: /* SUBSTITUTE EXISTING COMPONENTS */
3336: FORALL j IN 1..lv_job_count
3337: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3338: (last_update_date,
3339: last_updated_by,
3340: last_update_login,
3341: creation_date,

Line 3443: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3439:
3440:
3441: -- RESOURCE USAGE
3442: FORALL j IN 1..lv_job_count
3443: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3444: ( last_update_date,
3445: last_updated_by,
3446: last_update_login,
3447: creation_date,

Line 3554: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3550: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
3551: -- OPERATION RESOURCE_INSTANCES
3552:
3553: FORALL j IN 1..lv_job_count
3554: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3555: ( last_update_date,
3556: last_updated_by,
3557: last_update_login,
3558: creation_date,

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

3654: AND s.release_status = 1;
3655:
3656:
3657:
3658: --print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
3659: -- RESOURCE INSTANCE USAGES
3660: --print_debug_info('RESOURCE INSTANCE USAGES ');
3661:
3662: FORALL j IN 1..lv_job_count

Line 3663: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3659: -- RESOURCE INSTANCE USAGES
3660: --print_debug_info('RESOURCE INSTANCE USAGES ');
3661:
3662: FORALL j IN 1..lv_job_count
3663: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3664: ( last_update_date,
3665: last_updated_by,
3666: last_update_login,
3667: creation_date,

Line 4296: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4292: -- are the same as the planned date and quantity
4293:
4294: -- OPERATIONS
4295: FORALL j IN 1..lv_job_count
4296: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4297: (last_update_date,
4298: last_updated_by,
4299: last_update_login,
4300: creation_date,

Line 4397: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4393: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
4394:
4395: -- OPERATION RESOURCES
4396: FORALL j IN 1..lv_job_count
4397: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4398: ( last_update_date,
4399: last_updated_by,
4400: last_update_login,
4401: creation_date,

Line 4516: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4512: /* UPDATE EXISTING COMPONENTS *
4513: | We should set inventory_item_id_new to NULL |
4514: * */
4515: FORALL j IN 1..lv_job_count
4516: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4517: (last_update_date,
4518: last_updated_by,
4519: last_update_login,
4520: creation_date,

Line 4618: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4614:
4615: --Load Co-product/by-product component details
4616:
4617: FORALL j IN 1..lv_job_count
4618: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4619: (last_update_date,
4620: last_updated_by,
4621: last_update_login,
4622: creation_date,

Line 4715: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4711:
4712: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
4713: /* SUBSTITUTE EXISTING COMPONENTS ---------AKSHYA */
4714: FORALL j IN 1..lv_job_count
4715: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4716: (last_update_date,
4717: last_updated_by,
4718: last_update_login,
4719: creation_date,

Line 4820: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4816: AND s.release_status = 1;
4817: /*Code to insert the substitute component--new for USAF/CMRO */
4818:
4819: FORALL j IN 1..lv_job_count
4820: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4821: (last_update_date,
4822: last_updated_by,
4823: last_update_login,
4824: creation_date,

Line 4897: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4893: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
4894:
4895: -- RESOURCE USAGE
4896: FORALL j IN 1..lv_job_count
4897: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4898: ( last_update_date,
4899: last_updated_by,
4900: last_update_login,
4901: creation_date,

Line 5004: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5000: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
5001: -- OPERATION RESOURCE_INSTANCES
5002:
5003: FORALL j IN 1..lv_job_count
5004: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5005: ( last_update_date,
5006: last_updated_by,
5007: last_update_login,
5008: creation_date,

Line 5105: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

5101: -- print_debug_info('reschedule_wip_discrete_jobs: 888 sql%rowcount = '|| SQL%ROWCOUNT);
5102: -- RESOURCE INSTANCE USAGES
5103: -- print_debug_info('RESOURCE INSTANCE USAGES');
5104: FORALL j IN 1..lv_job_count
5105: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
5106: ( last_update_date,
5107: last_updated_by,
5108: last_update_login,
5109: creation_date,