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 8793: FROM WIP_PARAMETERS

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

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

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

Line 12135: --FROM WIP_PARAMETERS_V

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