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 648: DELETE MSC_WIP_JOB_DTLS_INTERFACE

644: END IF;
645: /* DELETE msc_wip_job_schedule_interface
646: WHERE sr_instance_id= arg_org_instance;
647:
648: DELETE MSC_WIP_JOB_DTLS_INTERFACE
649: WHERE sr_instance_id= arg_org_instance;
650: */
651: IF arg_loaded_reqs > 0 THEN
652: DECLARE po_group_by_name VARCHAR2(10);

Line 784: DELETE MSC_WIP_JOB_DTLS_INTERFACE

780: DELETE msc_wip_job_schedule_interface
781: WHERE sr_instance_id= arg_org_instance
782: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
783:
784: DELETE MSC_WIP_JOB_DTLS_INTERFACE
785: WHERE sr_instance_id= arg_org_instance
786: AND NVL(GROUP_ID,-1) = NVL(arg_wip_group_id, -1);
787:
788: DELETE MSC_PO_REQUISITIONS_INTERFACE

Line 807: DELETE MSC_WIP_JOB_DTLS_INTERFACE

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

Line 1098: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1094: /* OPERATION NETWORKS */
1095:
1096:
1097: FORALL j IN 1..lv_job_count
1098: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1099: (last_update_date,
1100: last_updated_by,
1101: last_update_login,
1102: creation_date,

Line 1152: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1148:
1149: /* Operations */
1150:
1151: FORALL j IN 1..lv_job_count
1152: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1153: (last_update_date,
1154: last_updated_by,
1155: last_update_login,
1156: creation_date,

Line 1215: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1211: s.sr_instance_id);
1212:
1213: /* Resources */
1214: FORALL j IN 1..lv_job_count
1215: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1216: (last_update_date,
1217: last_updated_by,
1218: last_update_login,
1219: creation_date,

Line 1339: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1335:
1336: /*Components*/
1337:
1338: FORALL j IN 1..lv_job_count
1339: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1340: (last_update_date,
1341: last_updated_by,
1342: last_update_login,
1343: creation_date,

Line 1438: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1434:
1435:
1436: /* Resource Usage */
1437: FORALL j IN 1..lv_job_count
1438: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1439: (last_update_date,
1440: last_updated_by,
1441: last_update_login,
1442: creation_date,

Line 1506: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1502: AND s.release_status = 1);
1503:
1504: -- dsr begin: Operation Resource Instances
1505: FORALL j IN 1..lv_job_count
1506: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1507: ( last_update_date,
1508: last_updated_by,
1509: last_update_login,
1510: creation_date,

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

1608: AND param.network_scheduling_method = 1
1609: AND s.release_status = 1;
1610:
1611:
1612: -- print_debug_info( 'Operation Resource Instances: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
1613: -- || SQL%ROWCOUNT
1614: -- );
1615:
1616: -- dsr: RESOURCE INSTANCE USAGES

Line 1619: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1615:
1616: -- dsr: RESOURCE INSTANCE USAGES
1617:
1618: FORALL j IN 1..lv_job_count
1619: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1620: ( last_update_date,
1621: last_updated_by,
1622: last_update_login,
1623: creation_date,

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

1715: AND param.network_scheduling_method = 1
1716: AND s.release_status = 1
1717: ;
1718:
1719: -- print_debug_info( 'Resource Instance Usage: rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = '
1720: -- || SQL%ROWCOUNT
1721: -- );
1722:
1723: -- dsr end

Line 1963: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

1959: /* OPERATION NETWORKS */
1960:
1961:
1962: FORALL j IN 1..lv_resched_jobs
1963: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
1964: (last_update_date,
1965: last_updated_by,
1966: last_update_login,
1967: creation_date,

Line 2020: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2016:
2017: /* Operations */
2018:
2019: FORALL j IN 1..lv_resched_jobs
2020: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2021: (last_update_date,
2022: last_updated_by,
2023: last_update_login,
2024: creation_date,

Line 2089: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2085: s.JOB_OP_SEQ_NUM);
2086:
2087: /* Resources */
2088: FORALL j IN 1..lv_resched_jobs
2089: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2090: (last_update_date,
2091: last_updated_by,
2092: last_update_login,
2093: creation_date,

Line 2216: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2212:
2213: /*Components*/
2214:
2215: FORALL j IN 1..lv_resched_jobs
2216: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2217: (last_update_date,
2218: last_updated_by,
2219: last_update_login,
2220: creation_date,

Line 2318: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2314:
2315:
2316: /* Resource Usage */
2317: FORALL j IN 1..lv_resched_jobs
2318: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2319: (last_update_date,
2320: last_updated_by,
2321: last_update_login,
2322: creation_date,

Line 2389: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2385: AND s.release_status = 1);
2386: -- dsr begin: Operation Resource Instances
2387:
2388: FORALL j IN 1..lv_resched_jobs
2389: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2390: ( last_update_date,
2391: last_updated_by,
2392: last_update_login,
2393: creation_date,

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

2493: AND param.network_scheduling_method = 1
2494: AND s.release_status = 1
2495: ;
2496:
2497: -- print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
2498: -- || sql%rowcount);
2499:
2500: FORALL j IN 1..lv_resched_jobs
2501: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

Line 2501: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2497: -- print_debug_info('Resource Instance: rows inserted into msc_wip_job_dtls_interface = '
2498: -- || sql%rowcount);
2499:
2500: FORALL j IN 1..lv_resched_jobs
2501: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2502: ( last_update_date,
2503: last_updated_by,
2504: last_update_login,
2505: creation_date,

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

2599: AND param.network_scheduling_method = 1
2600: AND s.release_status = 1
2601: ;
2602:
2603: -- print_debug_info('Resource Instance Usage: rows inserted into msc_wip_job_dtls_interface = '
2604: -- || sql%rowcount);
2605:
2606: -- dsr end
2607: RETURN lv_resched_jobs;

Line 2893: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2889: are the same as the planned date and quantity */
2890:
2891: /* OPERATIONS */
2892: FORALL j IN 1..lv_job_count
2893: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2894: (last_update_date,
2895: last_updated_by,
2896: last_update_login,
2897: creation_date,

Line 2996: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

2992: than apply the CY on new_order_qty. This logic to use cummulative_qty is added to remove the calc. errors */
2993:
2994: /* OPERATION RESOURCES */
2995: FORALL j IN 1..lv_job_count
2996: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
2997: ( last_update_date,
2998: last_updated_by,
2999: last_update_login,
3000: creation_date,

Line 3126: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3122: /* UPDATE EXISTING COMPONENTS *
3123: | We should set inventory_item_id_new to NULL |
3124: * */
3125: FORALL j IN 1..lv_job_count
3126: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3127: (last_update_date,
3128: last_updated_by,
3129: last_update_login,
3130: creation_date,

Line 3223: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3219: AND s.release_status = 1;
3220:
3221: --Loading Co-products/by-products for OPM orgs
3222: FORALL j IN 1..lv_job_count
3223: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3224: (last_update_date,
3225: last_updated_by,
3226: last_update_login,
3227: creation_date,

Line 3310: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3306:
3307: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
3308: /* SUBSTITUTE EXISTING COMPONENTS */
3309: FORALL j IN 1..lv_job_count
3310: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3311: (last_update_date,
3312: last_updated_by,
3313: last_update_login,
3314: creation_date,

Line 3416: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3412:
3413:
3414: -- RESOURCE USAGE
3415: FORALL j IN 1..lv_job_count
3416: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3417: ( last_update_date,
3418: last_updated_by,
3419: last_update_login,
3420: creation_date,

Line 3527: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3523: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
3524: -- OPERATION RESOURCE_INSTANCES
3525:
3526: FORALL j IN 1..lv_job_count
3527: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3528: ( last_update_date,
3529: last_updated_by,
3530: last_update_login,
3531: creation_date,

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

3627: AND s.release_status = 1;
3628:
3629:
3630:
3631: --print_debug_info('load_wip_discrete_jobs# rows inserted into MSC_WIP_JOB_DTLS_INTERFACE = ' || SQL%ROWCOUNT);
3632: -- RESOURCE INSTANCE USAGES
3633: --print_debug_info('RESOURCE INSTANCE USAGES ');
3634:
3635: FORALL j IN 1..lv_job_count

Line 3636: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3632: -- RESOURCE INSTANCE USAGES
3633: --print_debug_info('RESOURCE INSTANCE USAGES ');
3634:
3635: FORALL j IN 1..lv_job_count
3636: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3637: ( last_update_date,
3638: last_updated_by,
3639: last_update_login,
3640: creation_date,

Line 3990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

3986: -- are the same as the planned date and quantity
3987:
3988: -- OPERATIONS
3989: FORALL j IN 1..lv_job_count
3990: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
3991: (last_update_date,
3992: last_updated_by,
3993: last_update_login,
3994: creation_date,

Line 4091: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4087: --DBMS_OUTPUT.PUT_LINE('OPERATION_RESOURCE');
4088:
4089: -- OPERATION RESOURCES
4090: FORALL j IN 1..lv_job_count
4091: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4092: ( last_update_date,
4093: last_updated_by,
4094: last_update_login,
4095: creation_date,

Line 4209: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4205: /* UPDATE EXISTING COMPONENTS *
4206: | We should set inventory_item_id_new to NULL |
4207: * */
4208: FORALL j IN 1..lv_job_count
4209: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4210: (last_update_date,
4211: last_updated_by,
4212: last_update_login,
4213: creation_date,

Line 4313: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4309:
4310: --Load Co-product/by-product component details
4311:
4312: FORALL j IN 1..lv_job_count
4313: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4314: (last_update_date,
4315: last_updated_by,
4316: last_update_login,
4317: creation_date,

Line 4408: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4404:
4405: --DBMS_OUTPUT.PUT_LINE('LOAD SUBSTITUTE COMPONENTS');
4406: /* SUBSTITUTE EXISTING COMPONENTS ---------AKSHYA */
4407: FORALL j IN 1..lv_job_count
4408: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4409: (last_update_date,
4410: last_updated_by,
4411: last_update_login,
4412: creation_date,

Line 4514: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4510: --DBMS_OUTPUT.PUT_LINE('RESOURCE_USAGE');
4511:
4512: -- RESOURCE USAGE
4513: FORALL j IN 1..lv_job_count
4514: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4515: ( last_update_date,
4516: last_updated_by,
4517: last_update_login,
4518: creation_date,

Line 4620: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4616: -- print_debug_info('OPERATION RESOURCE_INSTANCES');
4617: -- OPERATION RESOURCE_INSTANCES
4618:
4619: FORALL j IN 1..lv_job_count
4620: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4621: ( last_update_date,
4622: last_updated_by,
4623: last_update_login,
4624: creation_date,

Line 4721: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE

4717: -- print_debug_info('reschedule_wip_discrete_jobs: 888 sql%rowcount = '|| SQL%ROWCOUNT);
4718: -- RESOURCE INSTANCE USAGES
4719: -- print_debug_info('RESOURCE INSTANCE USAGES');
4720: FORALL j IN 1..lv_job_count
4721: INSERT INTO MSC_WIP_JOB_DTLS_INTERFACE
4722: ( last_update_date,
4723: last_updated_by,
4724: last_update_login,
4725: creation_date,