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 5587: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);

5583: end if;
5584: end if;
5585:
5586: l_stmt_num := 700.2;
5587: delete from wip_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5588: delete from wip_operation_resources where wip_entity_id = v_wlji_wip_entity_id(v_index);
5589: delete from wip_requirement_operations where wip_entity_id = v_wlji_wip_entity_id(v_index);
5590: delete from wip_operation_yields where wip_entity_id = v_wlji_wip_entity_id(v_index);
5591:

Line 6075: delete from wip_operations

6071:
6072: l_stmt_num:= 704;
6073: if p_change_routing_reference = 1 OR p_change_bom_reference = 1 then
6074: begin
6075: delete from wip_operations
6076: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6077: delete from wip_operation_yields
6078: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6079: delete from wip_operation_resources

Line 6860: UPDATE WIP_OPERATIONS

6856: else
6857: l_qntydiff := 0;
6858: end if;
6859:
6860: UPDATE WIP_OPERATIONS
6861: SET
6862: FIRST_UNIT_START_DATE = decode(l_txnexist,
6863: 0, NVL(v_wlji_fusd(v_index), FIRST_UNIT_START_DATE), -- bug 3394520
6864: FIRST_UNIT_START_DATE),

Line 6927: FROM WIP_OPERATIONS

6923: --LBM enh: modified the expression on required_quantity
6924: UPDATE WIP_REQUIREMENT_OPERATIONS WRO
6925: SET WRO.DATE_REQUIRED =
6926: (SELECT NVL(MIN(FIRST_UNIT_START_DATE), v_wlji_fusd(v_index))
6927: FROM WIP_OPERATIONS
6928: WHERE ORGANIZATION_ID = v_wlji_org(v_index)
6929: AND WIP_ENTITY_ID = v_wlji_wip_entity_id(v_index)
6930: AND OPERATION_SEQ_NUM = ABS(WRO.OPERATION_SEQ_NUM)),
6931: LAST_UPDATED_BY = v_wlji_last_updt_by(v_index),

Line 6959: from wip_operations

6955: p_job_type => '') = 1 then
6956:
6957: select min(operation_seq_num)
6958: into min_op_seq_num
6959: from wip_operations
6960: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6961:
6962: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6963: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id

Line 6964: from bom_departments bd, wip_operations wo

6960: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6961:
6962: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6963: into l_scrap_account10, l_est_scrap_abs_account10, l_department_id
6964: from bom_departments bd, wip_operations wo
6965: where wo.wip_entity_id = v_wlji_wip_entity_id(v_index)
6966: and wo.operation_seq_num = min_op_seq_num
6967: and bd.department_id = wo.department_id;
6968:

Line 6994: from wip_operations

6990: end if;
6991:
6992: select max(operation_seq_num)
6993: into max_op_seq_num
6994: from wip_operations
6995: where wip_entity_id = v_wlji_wip_entity_id(v_index);
6996:
6997: select bd.scrap_account, bd.est_absorption_account, wo.department_id
6998: into l_scrap_account9999, l_est_scrap_abs_account9999, l_department_id

Line 6999: from bom_departments bd, wip_operations wo

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