APPS.WSMPLBMI dependencies on WIP_PARAMETERS

Line 1251: from wip_parameters

1247: l_override_no_move_no_skip number;
1248: begin
1249: select moves_over_no_move_statuses
1250: into l_override_no_move_no_skip
1251: from wip_parameters
1252: where organization_id = p_org_id;
1253:
1254: IF (G_LOG_LEVEL_STATEMENT >= l_log_level) THEN
1255: l_msg_tokens.delete;

Line 8795: FROM WIP_PARAMETERS

8791:
8792: l_stmt_num := 230;
8793: SELECT nvl(include_component_yield, 1)
8794: INTO l_wip_include_comp_yield
8795: FROM WIP_PARAMETERS
8796: WHERE organization_id = l_organization_id;
8797:
8798: --LBM enh: Modified the expression for quantity_relieved
8799: UPDATE wip_requirement_operations wro

Line 12129: --Bug 5051836:Replaced wip_parameters_v with wvis to fix the

12125: END IF;
12126:
12127: l_stmt_num := 10;
12128: --SELECT queue_enabled_flag, run_enabled_flag, to_move_enabled_flag, scrap_enabled_flag
12129: --Bug 5051836:Replaced wip_parameters_v with wvis to fix the
12130: --share memory violation
12131: SELECT DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE,1,1,0)),0,2,1),
12132: DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE,2,1,0)),0,2,1),
12133: DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE,3,

Line 12137: --FROM WIP_PARAMETERS_V

12133: DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE,3,
12134: DECODE(WVIS.RECORD_CREATOR,'USER',1,0),0)),0,2,1),
12135: DECODE(SUM(DECODE(WVIS.STEP_LOOKUP_TYPE,5,1,0)),0,2,1)
12136: INTO l_wip_queue_enabled_flag, l_wip_run_enabled_flag, l_wip_to_move_enabled_flag, l_wip_scrap_enabled_flag
12137: --FROM WIP_PARAMETERS_V
12138: FROM WIP_VALID_INTRAOPERATION_STEPS WVIS
12139: WHERE organization_id = p_organization_id;
12140:
12141: l_stmt_num := 20;