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.WSMPLBMI dependencies on WSM_COPY_OPERATIONS

Line 2183: FROM WSM_COPY_OPERATIONS WCO

2179: SET (FM_DEPARTMENT_ID,
2180: FM_DEPARTMENT_CODE) =
2181: (SELECT WCO.department_id,
2182: WCO.department_code
2183: FROM WSM_COPY_OPERATIONS WCO
2184: WHERE WCO.wip_entity_id = l_wip_entity_id
2185: AND WCO.operation_sequence_id = l_op_seq_id)
2186: WHERE WLMTI.header_id = p_header_id;
2187:

Line 2228: FROM WSM_COPY_OPERATIONS WCO

2224: l_end_std_op_id,
2225: l_end_dept_id,
2226: l_end_op_seq_num,
2227: l_end_op_code
2228: FROM WSM_COPY_OPERATIONS WCO
2229: WHERE WCO.wip_entity_id=l_wip_entity_id
2230: AND WCO.network_start_end='E';
2231: EXCEPTION
2232: WHEN no_data_found THEN

Line 2289: FROM WSM_COPY_OPERATIONS WCO

2285: --bug 3571019 changed l_scrap_acc_id to l_to_scrap_id for clarity
2286: -- l_scrap_acc_id,
2287: l_to_scrap_id,
2288: l_to_op_bkflsh_flag
2289: FROM WSM_COPY_OPERATIONS WCO
2290: WHERE WCO.wip_entity_id=l_wip_entity_id
2291: AND WCO.operation_seq_num = p_to_op_seq_num;
2292: EXCEPTION
2293: WHEN no_data_found THEN

Line 2509: FROM WSM_COPY_OPERATIONS WCO

2505: --bug 3571019 changed l_scrap_acc_id to l_to_scrap_id for clarity
2506: -- l_scrap_acc_id,
2507: l_to_scrap_id,
2508: l_to_op_bkflsh_flag
2509: FROM WSM_COPY_OPERATIONS WCO
2510: WHERE WCO.wip_entity_id=l_wip_entity_id
2511: AND WCO.operation_seq_num = p_to_op_seq_num;
2512: EXCEPTION
2513: WHEN no_data_found THEN

Line 3191: FROM WSM_COPY_OPERATIONS WCO

3187: ((p_to_intraop_step_type = WIP_CONSTANTS.SCRAP) OR (nvl(l_scrap_at_operation_flag, 1)=1)))
3188: THEN
3189: SELECT WCO.scrap_account
3190: INTO l_scrap_acc_id
3191: FROM WSM_COPY_OPERATIONS WCO
3192: WHERE WCO.wip_entity_id = l_wip_entity_id
3193: AND WCO.operation_seq_num = l_wo_rtg_op_seq_num;
3194: END IF;
3195:

Line 3315: FROM WSM_COPY_OPERATIONS WCO

3311: THEN
3312: BEGIN
3313: SELECT WCO.scrap_account
3314: INTO l_from_scrap_id
3315: FROM WSM_COPY_OPERATIONS WCO
3316: WHERE WCO.wip_entity_id = l_wip_entity_id
3317: AND WCO.operation_seq_num = l_wo_rtg_op_seq_num;
3318: EXCEPTION
3319: WHEN no_data_found THEN

Line 3394: WSM_COPY_OPERATIONS WCO

3390: IF (nvl(p_to_op_seq_num, -1) <> -1) THEN --regular move or jump inside rtg
3391: SELECT gcc.code_combination_id
3392: INTO l_temp
3393: FROM gl_code_combinations gcc,
3394: WSM_COPY_OPERATIONS WCO
3395: WHERE gcc.code_combination_id = l_wlmti_scrap_acct_id
3396: AND WCO.scrap_account = gcc.code_combination_id
3397: AND WCO.wip_entity_id = l_wip_entity_id
3398: AND WCO.operation_seq_num = decode(l_scrap_at_operation_flag,

Line 4028: FROM WSM_COPY_OPERATIONS WCO,

4024: IF (g_aps_wps_profile = 'Y') THEN
4025: BEGIN
4026: SELECT nvl(WCO.recommended, 'N')
4027: INTO l_recommended
4028: FROM WSM_COPY_OPERATIONS WCO,
4029: WIP_OPERATIONS WO
4030: WHERE WO.wip_entity_id = l_wip_entity_id
4031: AND WO.organization_id = p_org_id
4032: AND WO.operation_seq_num = l_cmp_fm_op_seq_num

Line 4624: FROM WSM_COPY_OPERATIONS WCO,

4620: IF (g_aps_wps_profile = 'Y') THEN
4621: BEGIN
4622: SELECT nvl(WCO.recommended, 'N')
4623: INTO l_recommended
4624: FROM WSM_COPY_OPERATIONS WCO,
4625: WIP_OPERATIONS WO
4626: WHERE WO.wip_entity_id = l_wip_entity_id
4627: AND WO.organization_id = p_org_id
4628: AND WO.operation_seq_num = l_fm_op_seq_num

Line 6198: --l_wco_fm_op_network_start WSM_COPY_OPERATIONS.network_start_end%TYPE;

6194: l_wltx_secondary_qty_tbl WSM_WIP_LOT_TXN_PVT.WSM_JOB_SECONDARY_QTY_TBL_TYPE;
6195: l_WSM_SERIAL_NUM_TBL WSM_SERIAL_SUPPORT_GRP.WSM_SERIAL_NUM_TBL;
6196: l_wip_include_comp_yield NUMBER;
6197: --Bug 5480482:Following variable declaration is commented.
6198: --l_wco_fm_op_network_start WSM_COPY_OPERATIONS.network_start_end%TYPE;
6199: --l_wco_to_op_network_end WSM_COPY_OPERATIONS.network_start_end%TYPE;
6200: --l_wo_min_op_seq_num NUMBER;
6201: l_undone_txn_source_code WIP_MOVE_TRANSACTIONS.source_code%type;
6202: l_mes_scrap_txn_id NUMBER; --bug 5446252

Line 6199: --l_wco_to_op_network_end WSM_COPY_OPERATIONS.network_start_end%TYPE;

6195: l_WSM_SERIAL_NUM_TBL WSM_SERIAL_SUPPORT_GRP.WSM_SERIAL_NUM_TBL;
6196: l_wip_include_comp_yield NUMBER;
6197: --Bug 5480482:Following variable declaration is commented.
6198: --l_wco_fm_op_network_start WSM_COPY_OPERATIONS.network_start_end%TYPE;
6199: --l_wco_to_op_network_end WSM_COPY_OPERATIONS.network_start_end%TYPE;
6200: --l_wo_min_op_seq_num NUMBER;
6201: l_undone_txn_source_code WIP_MOVE_TRANSACTIONS.source_code%type;
6202: l_mes_scrap_txn_id NUMBER; --bug 5446252
6203: --MES END

Line 8177: FROM WSM_COPY_OPERATIONS

8173: -- Bug 4480248 Added the condition ( AND l_to_op_seq_num is NOT NULL) in the IF statement below
8174: IF (((l_jump_flag <> 'Y') AND (l_transaction_type NOT IN (3, 4))) AND l_to_op_seq_num is NOT NULL) THEN
8175: SELECT nvl(operation_sequence_id, -2)
8176: INTO l_to_op_seq_id
8177: FROM WSM_COPY_OPERATIONS
8178: WHERE wip_entity_id=l_wip_entity_id
8179: AND operation_seq_num = l_to_op_seq_num;
8180: END IF;
8181: END IF;

Line 9557: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

9553: --BEGIN
9554: --if last op update wdj.actual_completion_date
9555: --SELECT WCO.network_start_end
9556: --INTO l_wco_to_op_network_end
9557: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO
9558: -- WHERE WCO.wip_entity_id = WO.wip_entity_id
9559: -- AND WCO.operation_seq_num = WO.wsm_op_seq_num
9560: --AND WO.wip_entity_id = l_wip_entity_id
9561: -- AND WO.operation_seq_num = l_job_to_op_seq_num;

Line 9591: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO

9587: --BEGIN
9588: --if 1st op update wdj.actual_start_date
9589: --SELECT WCO.network_start_end
9590: --INTO l_wco_fm_op_network_start
9591: --FROM WSM_COPY_OPERATIONS WCO, WIP_OPERATIONS WO
9592: --WHERE WCO.wip_entity_id = WO.wip_entity_id
9593: --AND WCO.operation_seq_num = WO.wsm_op_seq_num
9594: --AND WO.wip_entity_id = l_wip_entity_id
9595: --AND WO.operation_seq_num = l_fm_op_seq_num;

Line 12208: FROM WSM_COPY_OPERATIONS WCO

12204:
12205: l_stmt_num := 40;
12206: SELECT operation_seq_num
12207: INTO l_end_routing_operation
12208: FROM WSM_COPY_OPERATIONS WCO
12209: WHERE WCO.wip_entity_id = p_wip_entity_id
12210: AND WCO.network_start_end = 'E';
12211:
12212: l_stmt_num := 50;

Line 12757: FROM WSM_COPY_OPERATIONS WCO

12753:
12754: l_stmt_num := 40.1;
12755: SELECT operation_seq_num
12756: INTO l_end_routing_operation
12757: FROM WSM_COPY_OPERATIONS WCO
12758: WHERE WCO.wip_entity_id = p_wip_entity_id
12759: AND WCO.network_start_end = 'E';
12760:
12761: IF (p_routing_operation = l_end_routing_operation) THEN