APPS.WSMPLBMI dependencies on WSM_PARAMETERS

Line 418: FROM wsm_parameters

414: charge_jump_from_queue
415: INTO g_prev_op_seq_incr,
416: g_allow_bkw_move,
417: g_param_jump_fm_q
418: FROM wsm_parameters
419: WHERE organization_id = p_org_id;
420: --***VJ: End changes for removal of 9999***--
421:
422: --

Line 4319: from wsm_parameters

4315: /* JUMP_ENH: Commented the following because it's moved to the
4316: beginning and called only when the organization_id is changed
4317: select ALLOW_BACKWARD_MOVE_FLAG
4318: into l_allow_bkw_move
4319: from wsm_parameters
4320: where organization_id = p_org_id; */
4321:
4322: if (g_allow_bkw_move <> 1) then
4323: x_return_code := 1;

Line 5265: -- FROM wsm_parameters

5261: WHERE WIP_ENTITY_ID = l_wip_entity_id;
5262: --***VJ: Start Deletion for removal of 9999 ***--
5263: -- AND operation_seq_num NOT IN
5264: -- ( SELECT nvl(last_operation_seq_num, 9999)
5265: -- FROM wsm_parameters
5266: -- WHERE organization_id = p_org_id ) ;
5267: --***VJ: End Deletion for removal of 9999 ***--
5268: --End additions to fix bug #1496147
5269:

Line 6595: FROM wsm_parameters

6591: l_stmt_num := 90;
6592:
6593: SELECT charge_jump_from_queue
6594: INTO l_charge_jump_from_queue
6595: FROM wsm_parameters
6596: WHERE organization_id = l_organization_id;
6597: END IF;
6598:
6599: /* OSP Enhancement Changes Begin

Line 10401: WSM_PARAMETERS wp, -- ESA

10397: WHERE woy.rowid IN ((
10398: SELECT woy2.rowid
10399: FROM WIP_OPERATIONS wop2,
10400: WIP_OPERATION_YIELDS woy2,
10401: WSM_PARAMETERS wp, -- ESA
10402: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10403: WIP_MOVE_TRANSACTIONS wmt,
10404: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10405: --bug 3615826

Line 10489: WSM_PARAMETERS wp, -- ESA

10485: (
10486: SELECT woy2.rowid
10487: FROM WIP_OPERATIONS wop2,
10488: WIP_OPERATION_YIELDS woy2,
10489: WSM_PARAMETERS wp, -- ESA
10490: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10491: WIP_MOVE_TRANSACTIONS wmt,
10492: WSM_LOT_MOVE_TXN_INTERFACE wlmti
10493: --bug 3615826

Line 10590: WSM_PARAMETERS wp, -- ESA

10586: WHERE woy.rowid IN (
10587: SELECT woy2.rowid
10588: FROM WIP_OPERATIONS wop2,
10589: WIP_OPERATION_YIELDS woy2,
10590: WSM_PARAMETERS wp, -- ESA
10591: WIP_DISCRETE_JOBS wdj, -- NSLBJ
10592: WIP_MOVE_TXN_INTERFACE wti
10593: WHERE wti.group_id = l_wmti_group_id
10594: AND wti.process_phase = g_move_proc

Line 12146: FROM WSM_PARAMETERS

12142: SELECT nvl(show_next_op_by_default, 0),
12143: nvl(track_multi_usage_dates, 0), nvl(move_in_option, 2), nvl(move_to_next_op_option, 2)
12144: INTO l_wsm_show_next_op_by_default,
12145: l_wsm_mul_res_usage_dates, l_wsm_move_in, l_wsm_move_to_next_op
12146: FROM WSM_PARAMETERS
12147: WHERE organization_id = p_organization_id;
12148:
12149: l_stmt_num := 30;
12150: /********bug 5463926 Always look at BSO instead of BOS. For the case of non standard operation