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.MRP_AP_REL_PLAN_PUB dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 53: UPDATE wip_job_schedule_interface i

49: PROCEDURE SET_OPM_SCHEDULING_METHOD
50: IS
51: BEGIN
52:
53: UPDATE wip_job_schedule_interface i
54: SET i.scheduling_method=2
55: WHERE
56: i.group_id = G_OPM_WIP_GROUP_ID
57: AND i.load_type in(1,3);

Line 59: UPDATE wip_job_schedule_interface i

55: WHERE
56: i.group_id = G_OPM_WIP_GROUP_ID
57: AND i.load_type in(1,3);
58:
59: UPDATE wip_job_schedule_interface i
60: SET i.scheduling_method=1
61: WHERE
62: EXISTS(SELECT 1
63: FROM WIP_JOB_DTLS_INTERFACE jdi

Line 117: SELECT wip_job_schedule_interface_s.nextval,

113: l_resp_id NUMBER;
114: lv_log_msg varchar2(500);
115: BEGIN
116:
117: SELECT wip_job_schedule_interface_s.nextval,
118: mrp_workbench_query_s.nextval,
119: -- TO_NUMBER( FND_PROFILE.VALUE('MSC_RESOURCE_TYPE')),
120: TO_NUMBER( FND_PROFILE.VALUE('MSC_ALT_RES_PRIORITY')),
121: TO_NUMBER( FND_PROFILE.VALUE('MSC_SIMUL_RES_SEQ')),

Line 131: SELECT wip_job_schedule_interface_s.nextval

127: PV_SIM_RES_SEQ,
128: PV_REL_REQUEST_DATE
129: FROM DUAL;
130:
131: SELECT wip_job_schedule_interface_s.nextval
132: INTO G_OPM_WIP_GROUP_ID
133: FROM DUAL;
134:
135: p_wip_group_id := G_WIP_GROUP_ID;

Line 1937: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

1933: ||' HEADER_ID, '
1934: -- dsr added 2 new columns
1935: ||' Schedule_priority,'
1936: ||' Requested_completion_date '
1937: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
1938: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
1939: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
1940: ||' AND nvl(CFM_ROUTING_FLAG,0) = 3' ;
1941:

Line 2118: PROCEDURE LD_WIP_JOB_SCHEDULE_INTERFACE

2114: END LD_LOT_JOB_SCHEDULE_INTERFACE;
2115:
2116:
2117:
2118: PROCEDURE LD_WIP_JOB_SCHEDULE_INTERFACE
2119: ( o_request_id OUT NOCOPY NUMBER)
2120: IS
2121: lv_sqlstmt VARCHAR2(4000);
2122: lv_sqlstmt1 VARCHAR2(4000);

Line 2145: 'INSERT INTO WIP_JOB_SCHEDULE_INTERFACE'

2141: and nvl(a2m_dblink,NULL_DBLINK) = nvl(v_dblink,NULL_DBLINK)
2142: and ALLOW_RELEASE_FLAG=1;
2143:
2144: lv_sqlstmt:=
2145: 'INSERT INTO WIP_JOB_SCHEDULE_INTERFACE'
2146: ||' ( LAST_UPDATE_DATE,'
2147: ||' LAST_UPDATED_BY,'
2148: ||' CREATION_DATE,'
2149: ||' CREATED_BY,'

Line 2236: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2232: ||' BILL_RTG_EXPLOSION_FLAG,'
2233: ||' HEADER_ID,'
2234: ||' schedule_priority, ' -- dsr
2235: ||' requested_completion_date' -- need to check in ds code it is requested_completion_date
2236: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2237: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2238: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
2239: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
2240: ||' AND load_type <> 21 ' -- dsr: exclude oem: EAM_RESCHEDULE_WORK_RODER

Line 2413: FROM WIP_JOB_SCHEDULE_INTERFACE

2409: -- Submit 'WIP Mass Load' Request --
2410: BEGIN
2411: SELECT 1
2412: INTO lv_dummy
2413: FROM WIP_JOB_SCHEDULE_INTERFACE
2414: WHERE GROUP_ID= G_WIP_GROUP_ID
2415: AND ROWNUM=1;
2416:
2417: MODIFY_COMPONENT_REQUIREMENT;

Line 2445: FROM WIP_JOB_SCHEDULE_INTERFACE

2441: -- Submit 'OPM's WIP Mass Load' Request --
2442: BEGIN
2443: SELECT 1
2444: INTO lv_dummy
2445: FROM WIP_JOB_SCHEDULE_INTERFACE
2446: WHERE GROUP_ID= G_OPM_WIP_GROUP_ID
2447: AND ROWNUM=1;
2448:
2449: SET_OPM_SCHEDULING_METHOD;

Line 2473: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2469: BEGIN
2470:
2471: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2472: lv_sqlstmt := 'SELECT 1 '
2473: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2474: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2475: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2476: ||' AND LOAD_TYPE in (3,258)'
2477: ||' AND ROWNUM = 1 ';

Line 2503: END LD_WIP_JOB_SCHEDULE_INTERFACE;

2499: WHEN NO_DATA_FOUND THEN NULL;
2500: WHEN OTHERS THEN RAISE;
2501: END;
2502:
2503: END LD_WIP_JOB_SCHEDULE_INTERFACE;
2504:
2505: PROCEDURE LD_EAM_CMRO_SCHEDULE_INTERFACE
2506: ( o_request_id_eam OUT NOCOPY NUMBER,
2507: o_request_id_cmro OUT NOCOPY NUMBER,

Line 2542: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2538: BEGIN
2539:
2540: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2541: lv_sqlstmt := 'SELECT 1 '
2542: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2543: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2544: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2545: ||' AND MAINTENANCE_OBJECT_SOURCE =1'
2546: ||' AND ROWNUM = 1 ';

Line 2576: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2572: BEGIN
2573:
2574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2575: lv_sqlstmt := 'SELECT 1 '
2576: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2577: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2578: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2579: ||' AND MAINTENANCE_OBJECT_SOURCE =2'
2580: ---maintenance_object_source will be 2 for CMRO jobs

Line 2649: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2645: BEGIN
2646:
2647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2648: lv_sqlstmt := 'SELECT 1 '
2649: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2650: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2651: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2652: ||' AND MAINTENANCE_OBJECT_SOURCE =1'
2653: ||' AND ROWNUM = 1 ';

Line 2719: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

2715: BEGIN
2716:
2717: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '1 dblink is '|| lv_dblink);
2718: lv_sqlstmt := 'SELECT 1 '
2719: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
2720: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
2721: ||' AND GROUP_ID = (:G_WIP_GROUP_ID *-1)'
2722: ||' AND LOAD_TYPE=258'
2723: ||' AND MAINTENANCE_OBJECT_SOURCE =2'

Line 3181: from wip_job_schedule_interface a,

3177:
3178:
3179: Cursor C1 is
3180: Select a.header_id,min(bos.operation_seq_num) new_op_seq
3181: from wip_job_schedule_interface a,
3182: wip_job_dtls_interface b,
3183: bom_operation_Sequences bos,
3184: bom_operational_routings bor
3185: where a.group_id = b.group_id

Line 3209: from wip_job_schedule_interface a,

3205: b.parent_header_id,
3206: b.INVENTORY_ITEM_ID_OLD,
3207: b.ORGANIZATION_ID,
3208: b.OPERATION_SEQ_NUM
3209: from wip_job_schedule_interface a,
3210: wip_job_dtls_interface b
3211: where a.source_code = 'MSC'
3212: and a.group_id = G_WIP_GROUP_ID
3213: and a.group_id = b.group_id

Line 3227: from wip_job_schedule_interface a,

3223: b.OPERATION_SEQ_NUM;
3224:
3225: Cursor C3 is
3226: select b.rowid
3227: from wip_job_schedule_interface a,
3228: wip_job_dtls_interface b
3229: where a.source_code = 'MSC'
3230: and a.group_id = G_WIP_GROUP_ID
3231: and a.group_id = b.group_id

Line 3302: wip_job_schedule_interface jsi

3298: cursor cres_upd is select jdi.rowid,jdi.operation_seq_num,
3299: jdi.parent_header_id,rtng.common_routing_Sequence_id
3300: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3301: wip_job_dtls_interface jdi,
3302: wip_job_schedule_interface jsi
3303: where rtng.assembly_item_id (+) = jsi.primary_item_id -- dsr
3304: and jsi.group_id = G_WIP_GROUP_ID
3305: AND rtng.organization_id (+) = jsi.organization_id -- dsr
3306: AND NVL(rtng.alternate_routing_designator,' ')=

Line 3464: wip_job_schedule_interface jsi

3460: lv_routing_seq_id,
3461: lv_job_schedule_type,
3462: lv_wip_entity_id
3463: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3464: wip_job_schedule_interface jsi
3465: WHERE jsi.group_id = G_WIP_GROUP_ID
3466: AND jsi.load_type in(1,3) /* create standard job */
3467: AND rtng.assembly_item_id(+)= jsi.primary_item_id
3468: AND rtng.organization_id(+)= jsi.organization_id

Line 3521: UPDATE wip_job_schedule_interface

3517: END;
3518:
3519: IF nvl(lv_res_req_count,0) = 0 THEN
3520:
3521: UPDATE wip_job_schedule_interface
3522: SET first_unit_start_date=NULL,
3523: scheduling_method= WIP_CONSTANTS.ROUTING
3524: WHERE ROWID= lv_jsi_rowid(n);
3525:

Line 3530: UPDATE wip_job_schedule_interface

3526: GOTO next_c_std_job;
3527: ELSE
3528:
3529:
3530: UPDATE wip_job_schedule_interface
3531: set scheduling_method= WIP_CONSTANTS.ML_MANUAL
3532: WHERE ROWID= lv_jsi_rowid(n);
3533:
3534: END IF;

Line 3580: wip_job_schedule_interface jsi

3576: AND not exists(select jdi.operation_seq_num
3577: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3578: BOM_OPERATION_SEQUEnCES seqs,
3579: wip_job_dtls_interface jdi,
3580: wip_job_schedule_interface jsi
3581: where rtng.assembly_item_id= jsi.primary_item_id
3582: AND rtng.organization_id= jsi.organization_id
3583: and nvl(rtng.common_routing_sequence_id,rtng.routing_sequence_id) = os.routing_Sequence_id
3584: AND nvl(rtng.common_routing_sequence_id,rtng.routing_Sequence_id) = seqs.routing_sequence_id

Line 3634: wip_job_schedule_interface jsi

3630: AND not exists(select jdi.resource_id_new
3631: FROM BOM_OPERATIONAL_ROUTINGS rtng,
3632: BOM_OPERATION_SEQUENCES seqs,
3633: wip_job_dtls_interface jdi,
3634: wip_job_schedule_interface jsi
3635: where rtng.assembly_item_id= jsi.primary_item_id
3636: AND rtng.organization_id= jsi.organization_id
3637: AND nvl(rtng.common_routing_sequence_id,rtng.routing_sequence_id) = seqs.routing_sequence_id
3638: AND NVL(rtng.alternate_routing_designator,' ')=

Line 4621: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink

4617: ||' alternate_routing_designator, '
4618: ||' end_item_unit_number, '
4619: ||' schedule_group_id, '
4620: ||' build_sequence '
4621: ||' FROM MSC_WIP_JOB_SCHEDULE_INTERFACE'||lv_dblink
4622: ||' WHERE SR_INSTANCE_ID= :lv_instance_id'
4623: ||' AND GROUP_ID = :G_WIP_GROUP_ID'
4624: ||' AND nvl(CFM_ROUTING_FLAG,0) <> 3 '
4625: ||' AND load_type = 21 ' -- EAM_RESCHEDULE_WORK_RODER

Line 4911: FROM WIP_JOB_SCHEDULE_INTERFACE

4907: -- Submit EAM RESCHEDULE Request --
4908: BEGIN
4909: SELECT 1
4910: INTO lv_dummy
4911: FROM WIP_JOB_SCHEDULE_INTERFACE
4912: WHERE GROUP_ID= G_WIP_GROUP_ID
4913: AND ROWNUM=1;
4914:
4915: MODIFY_EAM_COMP_REQUIREMENT;

Line 4950: from eam_work_order_import a, -- wip_job_schedule_interface a,

4946: IS
4947:
4948: Cursor C1 is
4949: Select a.header_id,min(bos.operation_seq_num) new_op_seq
4950: from eam_work_order_import a, -- wip_job_schedule_interface a,
4951: eam_material_import b, -- wip_job_dtls_interface b,
4952: bom_operation_Sequences bos,
4953: bom_operational_routings bor
4954: where a.group_id = b.group_id

Line 4978: from eam_work_order_import a, -- wip_job_schedule_interface a,

4974: b.wip_entity_id, -- b.parent_header_id,
4975: b.INVENTORY_ITEM_ID, -- b.INVENTORY_ITEM_ID_OLD,
4976: b.ORGANIZATION_ID,
4977: b.OPERATION_SEQ_NUM
4978: from eam_work_order_import a, -- wip_job_schedule_interface a,
4979: eam_material_import b -- wip_job_dtls_interface b
4980: where a.source_code = 'MSC'
4981: and a.group_id = G_WIP_GROUP_ID
4982: and a.group_id = b.group_id

Line 4997: from eam_work_order_import a, -- wip_job_schedule_interface a,

4993: b.OPERATION_SEQ_NUM;
4994:
4995: Cursor C3 is
4996: select b.rowid
4997: from eam_work_order_import a, -- wip_job_schedule_interface a,
4998: eam_material_import b -- wip_job_dtls_interface b
4999: where a.source_code = 'MSC'
5000: and a.group_id = G_WIP_GROUP_ID
5001: and a.group_id = b.group_id