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 WSM_LOT_JOB_DTL_INTERFACE

Line 293: From WSM_LOT_JOB_DTL_INTERFACE jdi

289: /* check whether the details has been released for the job */
290:
291: select count(*)
292: into lv_details
293: From WSM_LOT_JOB_DTL_INTERFACE jdi
294: Where jdi.group_id = G_WIP_GROUP_ID
295: and jdi.parent_header_id = lv_header_id(n);
296:
297: If lv_details = 0 Then

Line 328: From WSM_LOT_JOB_DTL_INTERFACE jdi

324: jdi.ROUTING_OP_SEQ_NUM
325: BULK COLLECT INTO
326: lv_nwk_job_op_seq_num,
327: lv_nwk_op_seq_num
328: From WSM_LOT_JOB_DTL_INTERFACE jdi
329: Where jdi.group_id = G_WIP_GROUP_ID
330: and jdi.parent_header_id = lv_header_id(n)
331: and jdi.load_type = 3
332: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1

Line 332: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1

328: From WSM_LOT_JOB_DTL_INTERFACE jdi
329: Where jdi.group_id = G_WIP_GROUP_ID
330: and jdi.parent_header_id = lv_header_id(n)
331: and jdi.load_type = 3
332: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1
333: Where jdi1.group_id = G_WIP_GROUP_ID
334: and jdi1.parent_header_id = lv_header_id(n)
335: and jdi1.load_type = 1
336: and nvl(jdi1.JOB_OP_SEQ_NUM,-1) = nvl(jdi.JOB_OP_SEQ_NUM,-1)

Line 341: From WSM_LOT_JOB_DTL_INTERFACE jdi

337: and nvl(jdi1.ROUTING_OP_SEQ_NUM,-1) = nvl(jdi.ROUTING_OP_SEQ_NUM,-1));
338: /*union
339: Select to_number(NULL), --Bug#3432607
340: jdi.NEXT_ROUTING_OP_SEQ_NUM
341: From WSM_LOT_JOB_DTL_INTERFACE jdi
342: Where jdi.group_id = G_WIP_GROUP_ID
343: and jdi.parent_header_id = lv_header_id(n)
344: and jdi.load_type = 5
345: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1

Line 345: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1

341: From WSM_LOT_JOB_DTL_INTERFACE jdi
342: Where jdi.group_id = G_WIP_GROUP_ID
343: and jdi.parent_header_id = lv_header_id(n)
344: and jdi.load_type = 5
345: and not exists ( SELECT 1 from WSM_LOT_JOB_DTL_INTERFACE jdi1
346: Where jdi1.group_id = G_WIP_GROUP_ID
347: and jdi1.parent_header_id = lv_header_id(n)
348: and jdi1.load_type = 3
349: and jdi1.ROUTING_OP_SEQ_NUM = jdi.NEXT_ROUTING_OP_SEQ_NUM)

Line 351: from WSM_LOT_JOB_DTL_INTERFACE jdi1

347: and jdi1.parent_header_id = lv_header_id(n)
348: and jdi1.load_type = 3
349: and jdi1.ROUTING_OP_SEQ_NUM = jdi.NEXT_ROUTING_OP_SEQ_NUM)
350: and not exists (select 1
351: from WSM_LOT_JOB_DTL_INTERFACE jdi1
352: where jdi1.group_id = G_WIP_GROUP_ID
353: and jdi1.parent_header_id = lv_header_id(n)
354: and jdi1.load_type = 5
355: and jdi1.ROUTING_OP_SEQ_NUM = jdi.NEXT_ROUTING_OP_SEQ_NUM);*/

Line 366: INSERT INTO WSM_LOT_JOB_DTL_INTERFACE --Bug#3432607

362: -- FORALL j in 1..lv_un_op_cnt
363:
364: /* insert unscheduled operations with start_date and completion date as null
365:
366: INSERT INTO WSM_LOT_JOB_DTL_INTERFACE --Bug#3432607
367: ( last_update_date,
368: last_updated_by,
369: last_update_login,
370: creation_date,

Line 406: UPDATE WSM_LOT_JOB_DTL_INTERFACE jdi

402:
403:
404: /* For Bug 3608361 -- we need not set start_date and completion date as null for unscheduled operations */
405: /*
406: UPDATE WSM_LOT_JOB_DTL_INTERFACE jdi
407: SET operation_start_date = null, operation_completion_date = null
408: WHERE jdi.group_id = G_WIP_GROUP_ID
409: AND jdi.parent_header_id = lv_header_id(n)
410: AND jdi.load_type = 3

Line 436: From WSM_LOT_JOB_DTL_INTERFACE jdi,

432: BULK COLLECT INTO lv_pri_res_rowid,
433: lv_pri_res_seq_num,
434: lv_pri_sub_grp_num,
435: lv_pri_schd_seq_num
436: From WSM_LOT_JOB_DTL_INTERFACE jdi,
437: bom_operation_resources bor,
438: bom_operation_sequences bos
439: Where jdi.group_id = G_WIP_GROUP_ID
440: and jdi.parent_header_id = lv_header_id(n)

Line 459: UPDATE WSM_LOT_JOB_DTL_INTERFACE set resource_seq_num = lv_pri_res_seq_num(k),

455:
456: IF lv_pri_res_cnt > 0 THEN
457:
458: FORALL k IN 1..lv_pri_res_cnt
459: UPDATE WSM_LOT_JOB_DTL_INTERFACE set resource_seq_num = lv_pri_res_seq_num(k),
460: substitute_group_num = lv_pri_sub_grp_num(k),
461: schedule_seq_num = lv_pri_schd_seq_num(k)
462: WHERE rowid = lv_pri_res_rowid(k);
463:

Line 482: From WSM_LOT_JOB_DTL_INTERFACE jdi,

478: bsor.schedule_seq_num
479: BULK COLLECT INTO lv_alt_res_rowid,
480: lv_alt_sub_grp_num,
481: lv_alt_schd_seq_num
482: From WSM_LOT_JOB_DTL_INTERFACE jdi,
483: bom_operation_resources bor,
484: bom_operation_sequences bos,
485: bom_sub_operation_resources bsor
486: Where jdi.group_id = G_WIP_GROUP_ID

Line 507: UPDATE WSM_LOT_JOB_DTL_INTERFACE set substitute_group_num = lv_alt_sub_grp_num(k),

503:
504: IF lv_alt_res_cnt > 0 THEN
505:
506: FORALL k IN 1..lv_alt_res_cnt
507: UPDATE WSM_LOT_JOB_DTL_INTERFACE set substitute_group_num = lv_alt_sub_grp_num(k),
508: schedule_seq_num = lv_alt_schd_seq_num(k),
509: resource_seq_num = null
510: WHERE rowid = lv_alt_res_rowid(k);
511:

Line 557: wsm_lot_job_dtl_interface jdi

553: , lv_unschd_parent_seq_num
554: -- , lv_unschd_schedule_seq_num
555: from bom_operation_resources bor,
556: bom_operation_sequences bos,
557: wsm_lot_job_dtl_interface jdi
558: Where bor.schedule_flag = 2
559: and bor.schedule_seq_num = jdi.schedule_seq_num
560: and nvl(jdi.replacement_group_num,0) = 0
561: and bos.operation_seq_num = jdi.routing_op_seq_num

Line 588: wsm_lot_job_dtl_interface jdi

584: , jdi.max_assigned_units --- sbala
585: , jdi.parent_resource_seq_num
586: from bom_sub_operation_resources bsor,
587: bom_operation_sequences bos,
588: wsm_lot_job_dtl_interface jdi
589: Where bsor.schedule_flag = 2
590: and bsor.schedule_seq_num = jdi.schedule_seq_num
591: and jdi.replacement_group_num = bsor.replacement_group_num
592: and bos.operation_seq_num = jdi.routing_op_seq_num

Line 620: wsm_lot_job_dtl_interface jdi

616: , jdi.max_assigned_units --- sbala
617: , jdi.parent_resource_seq_num --- sbala
618: from bom_operation_resources bor,
619: bom_operation_sequences bos,
620: wsm_lot_job_dtl_interface jdi
621: Where bor.schedule_flag = 2
622: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
623: where jdi1.group_id = G_WIP_GROUP_ID
624: and jdi1.parent_header_id = lv_header_id(n)

Line 622: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1

618: from bom_operation_resources bor,
619: bom_operation_sequences bos,
620: wsm_lot_job_dtl_interface jdi
621: Where bor.schedule_flag = 2
622: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
623: where jdi1.group_id = G_WIP_GROUP_ID
624: and jdi1.parent_header_id = lv_header_id(n)
625: and jdi1.routing_op_seq_num = bos.operation_seq_num
626: and jdi1.schedule_seq_num = bor.schedule_seq_num)

Line 643: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

639: IF lv_unschd_res_cnt > 0 Then
640:
641: For l in 1..lv_unschd_res_cnt LOOP
642:
643: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
644: ( last_update_date,
645: last_updated_by,
646: last_update_login,
647: creation_date,

Line 745: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

741: IF lv_unres_cnt > 0 Then
742:
743: For l in 1..lv_unres_cnt LOOP
744:
745: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
746: ( last_update_date,
747: last_updated_by,
748: last_update_login,
749: creation_date,

Line 793: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

789: sysdate
790: From Dual;
791:
792: /* Bug 3344136
793: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
794: ( last_update_date,
795: last_updated_by,
796: last_update_login,
797: creation_date,

Line 866: From WSM_LOT_JOB_DTL_INTERFACE jdi,

862: lv_res_rowid,
863: lv_res_seq_num,
864: lv_sub_grp_num,
865: lv_schd_seq_num
866: From WSM_LOT_JOB_DTL_INTERFACE jdi,
867: WSM_COPY_OP_RESOURCES wcor
868: Where jdi.group_id = G_WIP_GROUP_ID
869: and jdi.parent_header_id = lv_header_id(n)
870: -- and jdi.load_type in (1,4)

Line 886: UPDATE WSM_LOT_JOB_DTL_INTERFACE set resource_seq_num = lv_res_seq_num(k),

882:
883: IF lv_res_cnt > 0 THEN
884:
885: FORALL k IN 1..lv_res_cnt
886: UPDATE WSM_LOT_JOB_DTL_INTERFACE set resource_seq_num = lv_res_seq_num(k),
887: substitute_group_num = lv_sub_grp_num(k),
888: schedule_seq_num = lv_schd_seq_num(k)
889: WHERE rowid = lv_res_rowid(k);
890:

Line 909: From WSM_LOT_JOB_DTL_INTERFACE jdi,

905: lv_cur_op_res_rowid,
906: lv_cur_op_res_seq_num,
907: lv_cur_op_sub_grp_num,
908: lv_cur_op_schd_seq_num
909: From WSM_LOT_JOB_DTL_INTERFACE jdi,
910: wip_operation_resources wor
911: Where jdi.group_id = G_WIP_GROUP_ID
912: and jdi.parent_header_id = lv_header_id(n)
913: -- and jdi.load_type in (1,4)

Line 925: From WSM_LOT_JOB_DTL_INTERFACE jdi,

921: Select jdi.rowid,
922: wsor.resource_seq_num,
923: wsor.substitute_group_num,
924: wsor.schedule_seq_num
925: From WSM_LOT_JOB_DTL_INTERFACE jdi,
926: wip_sub_operation_resources wsor
927: Where jdi.group_id = G_WIP_GROUP_ID
928: and jdi.parent_header_id = lv_header_id(n)
929: -- and jdi.load_type in (1,4)

Line 942: UPDATE WSM_LOT_JOB_DTL_INTERFACE set substitute_group_num = lv_cur_op_sub_grp_num(k),

938:
939: IF lv_cur_op_res_cnt > 0 THEN
940:
941: FORALL k IN 1..lv_cur_op_res_cnt
942: UPDATE WSM_LOT_JOB_DTL_INTERFACE set substitute_group_num = lv_cur_op_sub_grp_num(k),
943: schedule_seq_num = lv_cur_op_schd_seq_num(k),
944: resource_seq_num = lv_cur_op_res_seq_num(k)
945: WHERE rowid = lv_cur_op_res_rowid(k);
946:

Line 974: wsm_lot_job_dtl_interface jdi

970: lv_unschd_subs_grp_num,
971: lv_unschd_rtng_op_seq_num,
972: lv_unschd_load_type
973: from wip_operation_resources wor,
974: wsm_lot_job_dtl_interface jdi
975: where wor.scheduled_flag = 2
976: and wor.schedule_seq_num = jdi.schedule_seq_num
977: and jdi.replacement_group_num = nvl(wor.replacement_group_num,0)
978: and wor.operation_seq_num = jdi.job_op_seq_num

Line 994: wsm_lot_job_dtl_interface jdi

990: wsor.substitute_group_num,
991: jdi.routing_op_seq_num,
992: jdi.load_type
993: from wip_sub_operation_resources wsor,
994: wsm_lot_job_dtl_interface jdi
995: where wsor.scheduled_flag = 2
996: and wsor.schedule_seq_num = jdi.schedule_seq_num
997: and jdi.replacement_group_num = nvl(wsor.replacement_group_num,0)
998: and wsor.operation_seq_num = jdi.job_op_seq_num

Line 1015: wsm_lot_job_dtl_interface jdi

1011: wor.substitute_group_num,
1012: jdi.routing_op_seq_num,
1013: jdi.load_type
1014: from wip_operation_resources wor,
1015: wsm_lot_job_dtl_interface jdi
1016: Where wor.scheduled_flag = 2
1017: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1018: where jdi1.group_id = G_WIP_GROUP_ID
1019: and jdi1.parent_header_id = lv_header_id(n)

Line 1017: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1

1013: jdi.load_type
1014: from wip_operation_resources wor,
1015: wsm_lot_job_dtl_interface jdi
1016: Where wor.scheduled_flag = 2
1017: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1018: where jdi1.group_id = G_WIP_GROUP_ID
1019: and jdi1.parent_header_id = lv_header_id(n)
1020: and jdi1.job_op_seq_num = wor.operation_seq_num
1021: and jdi1.schedule_seq_num = wor.schedule_seq_num)

Line 1035: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1031: IF lv_unschd_res_cnt > 0 Then
1032:
1033: For l in 1..lv_unschd_res_cnt LOOP
1034:
1035: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1036: ( last_update_date,
1037: last_updated_by,
1038: last_update_login,
1039: creation_date,

Line 1126: wsm_lot_job_dtl_interface jdi

1122: lv_unschd_rep_grp_num,
1123: lv_unschd_subs_grp_num,
1124: lv_unschd_load_type
1125: from wsm_copy_op_resources wcor,
1126: wsm_lot_job_dtl_interface jdi
1127: Where wcor.schedule_flag = 2
1128: and wcor.schedule_seq_num = jdi.schedule_seq_num
1129: and jdi.replacement_group_num = wcor.replacement_group_num
1130: and wcor.operation_seq_num = jdi.ROUTING_op_seq_num

Line 1147: wsm_lot_job_dtl_interface jdi

1143: nvl(wcor.replacement_group_num,0),
1144: wcor.substitute_group_num,
1145: jdi.load_type
1146: from wsm_copy_op_resources wcor,
1147: wsm_lot_job_dtl_interface jdi
1148: Where wcor.schedule_flag = 2
1149: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1150: where jdi1.group_id = G_WIP_GROUP_ID
1151: and jdi1.parent_header_id = lv_header_id(n)

Line 1149: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1

1145: jdi.load_type
1146: from wsm_copy_op_resources wcor,
1147: wsm_lot_job_dtl_interface jdi
1148: Where wcor.schedule_flag = 2
1149: and not exists (select schedule_seq_num from wsm_lot_job_dtl_interface jdi1
1150: where jdi1.group_id = G_WIP_GROUP_ID
1151: and jdi1.parent_header_id = lv_header_id(n)
1152: and jdi1.ROUTING_op_seq_num = wcor.operation_seq_num
1153: and jdi1.schedule_seq_num = wcor.schedule_seq_num)

Line 1169: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1165: IF lv_unschd_res_cnt > 0 Then
1166:
1167: For l in 1..lv_unschd_res_cnt LOOP
1168:
1169: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1170: ( last_update_date,
1171: last_updated_by,
1172: last_update_login,
1173: creation_date,

Line 1251: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1247: IF lv_unres_cnt > 0 Then
1248:
1249: For l in 1..lv_unres_cnt LOOP
1250:
1251: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1252: ( last_update_date,
1253: last_updated_by,
1254: last_update_login,
1255: creation_date,

Line 1299: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1295: sysdate
1296: From Dual;
1297:
1298: /* Bug 3344136
1299: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1300: ( last_update_date,
1301: last_updated_by,
1302: last_update_login,
1303: creation_date,

Line 1394: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1390: IF lv_unres_cnt > 0 Then
1391:
1392: For l in 1..lv_unres_cnt LOOP
1393:
1394: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1395: ( last_update_date,
1396: last_updated_by,
1397: last_update_login,
1398: creation_date,

Line 1474: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1470: IF lv_unres_cnt > 0 Then
1471:
1472: For l in 1..lv_unres_cnt LOOP
1473:
1474: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1475: ( last_update_date,
1476: last_updated_by,
1477: last_update_login,
1478: creation_date,

Line 1521: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1517: 1,
1518: sysdate
1519: From Dual;
1520: /*Bug 3344136
1521: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1522: ( last_update_date,
1523: last_updated_by,
1524: last_update_login,
1525: creation_date,

Line 1616: Insert INTO WSM_LOT_JOB_DTL_INTERFACE

1612: IF lv_unres_cnt > 0 Then
1613:
1614: For l in 1..lv_unres_cnt LOOP
1615:
1616: Insert INTO WSM_LOT_JOB_DTL_INTERFACE
1617: ( last_update_date,
1618: last_updated_by,
1619: last_update_login,
1620: creation_date,

Line 1693: WSM_LOT_JOB_DTL_INTERFACE b,

1689:
1690: Cursor C1 is
1691: Select a.header_id,min(bos.operation_seq_num) new_op_seq
1692: from WSM_LOT_JOB_INTERFACE a,
1693: WSM_LOT_JOB_DTL_INTERFACE b,
1694: bom_operation_Sequences bos,
1695: bom_operational_routings bor
1696: where a.group_id = b.group_id
1697: and a.group_id = G_WIP_GROUP_ID

Line 1722: WSM_LOT_JOB_DTL_INTERFACE b

1718: b.parent_header_id,
1719: b.INVENTORY_ITEM_ID_NEW,
1720: b.ROUTING_OP_SEQ_NUM
1721: from WSM_LOT_JOB_INTERFACE a,
1722: WSM_LOT_JOB_DTL_INTERFACE b
1723: where a.source_code = 'MSC'
1724: and a.group_id = G_WIP_GROUP_ID
1725: and a.group_id = b.group_id
1726: and a.header_id = b.parent_header_id

Line 1742: WSM_LOT_JOB_DTL_INTERFACE b

1738:
1739: Cursor C3 is
1740: select b.rowid
1741: from WSM_LOT_JOB_INTERFACE a,
1742: WSM_LOT_JOB_DTL_INTERFACE b
1743: where a.source_code = 'MSC'
1744: and a.group_id = G_WIP_GROUP_ID
1745: and a.group_id = b.group_id
1746: and a.header_id = b.parent_header_id

Line 1752: from WSM_LOT_JOB_DTL_INTERFACE c

1748: and b.substitution_type = 4
1749: and b.process_phase = 1
1750: and b.process_status = 1
1751: and b.rowid not in (select min(c.rowid)
1752: from WSM_LOT_JOB_DTL_INTERFACE c
1753: where b.group_id = c.group_id
1754: and b.parent_header_id = c.parent_header_id
1755: and b.INVENTORY_ITEM_ID_NEW = c.INVENTORY_ITEM_ID_NEW
1756: and b.ROUTING_OP_SEQ_NUM = c.ROUTING_OP_SEQ_NUM

Line 1771: update WSM_LOT_JOB_DTL_INTERFACE

1767:
1768: For I in C1
1769:
1770: loop
1771: update WSM_LOT_JOB_DTL_INTERFACE
1772: set routing_op_Seq_num = I.new_op_seq
1773: where parent_header_id = I.header_id
1774: and routing_op_seq_num = 1
1775: and group_id = G_WIP_GROUP_ID

Line 1784: update WSM_LOT_JOB_DTL_INTERFACE

1780:
1781: For J in C2
1782:
1783: loop
1784: update WSM_LOT_JOB_DTL_INTERFACE
1785: set QUANTITY_PER_ASSEMBLY = J.qty_per_assy,
1786: REQUIRED_QUANTITY = J.reqd_qty,
1787: MPS_REQUIRED_QUANTITY = J.mps_reqd_qty
1788: where group_id = J.group_id

Line 1803: delete WSM_LOT_JOB_DTL_INTERFACE

1799: For K in C3
1800:
1801: loop
1802:
1803: delete WSM_LOT_JOB_DTL_INTERFACE
1804: where rowid = K.rowid;
1805:
1806: End loop;
1807:

Line 1947: 'INSERT INTO WSM_LOT_JOB_DTL_INTERFACE'

1943:
1944: BEGIN
1945:
1946: lv_sqlstmt:=
1947: 'INSERT INTO WSM_LOT_JOB_DTL_INTERFACE'
1948: || '(RECORD_ID, '
1949: || 'GROUP_ID, '
1950: || 'PARENT_HEADER_ID, '
1951: || 'LOAD_TYPE, '

Line 2063: update WSM_LOT_JOB_DTL_INTERFACE wdi

2059:
2060:
2061: EXECUTE IMMEDIATE lv_sqlstmt USING lv_instance_id,G_WIP_GROUP_ID;
2062:
2063: update WSM_LOT_JOB_DTL_INTERFACE wdi
2064: set wdi.parent_header_id = (select header_id from wsm_lot_job_interface whi
2065: where wdi.parent_header_id = whi.interface_id
2066: and wdi.GROUP_ID = whi.GROUP_ID
2067: and whi.GROUP_ID = G_WIP_GROUP_ID) ;