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.WSMPLBJI dependencies on WIP_OPERATIONS

Line 809: from wip_operations

805:
806: l_stmt_num := 75;
807: select operation_seq_num
808: into abb_op_seq_num
809: from wip_operations
810: where wip_entity_id = p_wip_entity_id
811: and operation_sequence_id = wsmputil.replacement_op_seq_id(
812: l_bon_seq_id1,
813: p_routing_revision_date);

Line 818: from wip_operations

814:
815: l_stmt_num := 76;
816: select max(operation_seq_num)
817: into max_op_seq_num
818: from wip_operations
819: where wip_entity_id = p_wip_entity_id;
820:
821:
822: l_stmt_num := 80;

Line 824: UPDATE WIP_OPERATIONS WO

820:
821:
822: l_stmt_num := 80;
823:
824: UPDATE WIP_OPERATIONS WO
825: set wo.previous_operation_seq_num =
826: (select max(operation_seq_num)
827: from wip_operations
828: where wip_entity_id = p_wip_entity_id

Line 827: from wip_operations

823:
824: UPDATE WIP_OPERATIONS WO
825: set wo.previous_operation_seq_num =
826: (select max(operation_seq_num)
827: from wip_operations
828: where wip_entity_id = p_wip_entity_id
829: and operation_seq_num < wo.operation_seq_num),
830: wo.next_operation_seq_num =
831: (select min(operation_seq_num)

Line 832: from wip_operations

828: where wip_entity_id = p_wip_entity_id
829: and operation_seq_num < wo.operation_seq_num),
830: wo.next_operation_seq_num =
831: (select min(operation_seq_num)
832: from wip_operations
833: where wip_entity_id = p_wip_entity_id
834: and operation_seq_num > wo.operation_seq_num),
835: wo.quantity_in_queue = decode(operation_seq_num, max_op_seq_num,
836: (decode(p_status_type, 3,

Line 845: update WIP_OPERATIONS

841: if (lbji_debug = 'Y') then
842: fnd_file.put_line(fnd_file.log,'update wo('||l_stmt_num||'): '|| SQL%ROWCOUNT);
843: end if;
844:
845: update WIP_OPERATIONS
846: --Bug 5207481:Actual quantity changes for bonus:costed_quantity_completed
847: -- is updated instead of quantity_completed.
848: set wsm_costed_quantity_completed = p_start_quantity
849: --Bug 5510126:Scheduled quantity is getting populated in insert_procedure

Line 1637: -- This procedure does not populate any quantity value (except scheduled_quantity) in wip_operations.

1633: -- PROCEDURE insert_procedure
1634: -- ==============================================================================================
1635: --***********************************************************************************************
1636:
1637: -- This procedure does not populate any quantity value (except scheduled_quantity) in wip_operations.
1638: -- Quantity is populated in build_lbji_info according to whether the job is unreleased, or bonus
1639: -- (released a special case of bonus). Note however that wsmpwrot.populate_wro called from this
1640: -- operation populates quantity values in wro. Also, this procedure doesn't update the prev/vext_op_seq_num
1641: -- in wo. That's taken care of in build_lbji_info. It's more efficient that way.

Line 1745: INSERT INTO WIP_OPERATIONS

1741: raise no_dept_error;
1742: end if;
1743:
1744: l_stat_num := 50;
1745: INSERT INTO WIP_OPERATIONS
1746: (WIP_ENTITY_ID,
1747: OPERATION_SEQ_NUM,
1748: ORGANIZATION_ID,
1749: LAST_UPDATE_DATE,

Line 1876: AND NOT EXISTS (select 'x' from wip_operations

1872: -- EC: BUG2754825
1873:
1874: --EC: CZH.I_OED-1
1875: AND OPERATION_SEQUENCE_ID = p_seq_id
1876: AND NOT EXISTS (select 'x' from wip_operations
1877: where wip_entity_id = p_wip_entity_id
1878: and operation_sequence_id = p_seq_id
1879: and operation_seq_num = p_job_seq_num);
1880: --bugfix 2026218

Line 1939: FROM WIP_OPERATIONS WO

1935: p_prog_updt_date,
1936: NULL,
1937: l_scrap_account,
1938: l_est_scrap_abs_account
1939: FROM WIP_OPERATIONS WO
1940: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
1941: AND WO.OPERATION_SEQUENCE_ID = p_seq_id
1942: AND WO.OPERATION_SEQ_NUM NOT IN (SELECT WOY.OPERATION_SEQ_NUM
1943: FROM WIP_OPERATION_YIELDS WOY

Line 2002: WIP_OPERATIONS OPS

1998: 0
1999: -- ST : Detailed Scheduling --
2000: FROM BOM_RESOURCES RSC,
2001: BOM_OPERATION_RESOURCES ORS,
2002: WIP_OPERATIONS OPS
2003: WHERE OPS.ORGANIZATION_ID = p_organization_id
2004: AND OPS.WIP_ENTITY_ID = p_wip_entity_id
2005: AND OPS.OPERATION_SEQUENCE_ID = ORS.OPERATION_SEQUENCE_ID
2006: AND ORS.RESOURCE_ID = RSC.RESOURCE_ID

Line 5593: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);

5589: end if;
5590: end if;
5591:
5592: l_stmt_num := 700.2;
5593: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5594: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);
5595: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5596: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);
5597:

Line 6081: delete from wip_operations

6077:
6078: l_stmt_num:= 704;
6079: if p_change_routing_reference = 1 OR p_change_bom_reference = 1 then
6080: begin
6081: delete from wip_operations
6082: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6083: delete from wip_operation_yields
6084: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6085: delete from wip_operation_resources

Line 6866: UPDATE WIP_OPERATIONS

6862: else
6863: l_qntydiff := 0;
6864: end if;
6865:
6866: UPDATE WIP_OPERATIONS
6867: SET
6868: FIRST_UNIT_START_DATE = decode(l_txnexist,
6869: 0, NVL(v_wlji_fusd(v_index), FIRST_UNIT_START_DATE), -- bug 3394520
6870: FIRST_UNIT_START_DATE),

Line 6933: FROM WIP_OPERATIONS

6929: --LBM enh: modified the expression on required_quantity
6930: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
6931: SET WRO.DATE_REQUIRED =
6932: (SELECT NVL(MIN(FIRST_UNIT_START_DATE), v_wlji_fusd(v_index))
6933: FROM WIP_OPERATIONS
6934: WHERE ORGANIZATION_ID = v_wlji_org(v_index)
6935: AND WIP_ENTITY_ID = v_wlji_wip_entity_id(v_index)
6936: AND OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM)),
6937: LAST_UPDATED_BY = v_wlji_last_updt_by(v_index),

Line 6965: from wip_operations

6961: p_job_type => '') = 1 then
6962:
6963: select min(operation_seq_num)
6964: into min_op_seq_num
6965: from wip_operations
6966: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6967:
6968: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6969: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id

Line 6970: from bom_departments bd, wip_operations wo

6966: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6967:
6968: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6969: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id
6970: from bom_departments bd, wip_operations wo
6971: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
6972: and wo.operation_seq_num = min_op_seq_num
6973: and bd.department_id = wo.department_id;
6974:

Line 7000: from wip_operations

6996: end if;
6997:
6998: select max(operation_seq_num)
6999: into max_op_seq_num
7000: from wip_operations
7001: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7002:
7003: select bd.scrap_account, bd.est_absorption_account, wo.department_id
7004: into l_scrap_account9999, l_est_scrap_abs_account9999, l_department_id

Line 7005: from bom_departments bd, wip_operations wo

7001: where wip_entity_id = v_wlji_wip_entity_id(v_index);
7002:
7003: select bd.scrap_account, bd.est_absorption_account, wo.department_id
7004: into l_scrap_account9999, l_est_scrap_abs_account9999, l_department_id
7005: from bom_departments bd, wip_operations wo
7006: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
7007: and wo.operation_seq_num = max_op_seq_num
7008: and bd.department_id = wo.department_id;
7009: