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 10399: WSM_PARAMETERS wp, -- ESA

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

Line 10487: WSM_PARAMETERS wp, -- ESA

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

Line 10588: WSM_PARAMETERS wp, -- ESA

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

Line 12144: FROM WSM_PARAMETERS

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