APPS.WSM_JOBCOPIES_PVT dependencies on WSM_PARAMETERS

Line 3646: from wsm_parameters

3642:
3643: IF p_insert_wip = 1 THEN
3644: select nvl(OP_SEQ_NUM_INCREMENT, 10)
3645: into l_op_seq_incr
3646: from wsm_parameters
3647: where ORGANIZATION_ID = p_org_id;
3648: END IF;
3649:
3650: INSERT into WSM_LOT_BASED_JOBS

Line 4861: FROM wsm_parameters wp,

4857: wdj.bom_revision_date,
4858: wdj.wip_supply_type,
4859: 1 upg_success, -- Will indicate Upgrade Successful or failure in the PLSQL table t_upgrade_jobs
4860: '' err_buf -- Will contain the error message for failed jobs
4861: FROM wsm_parameters wp,
4862: wip_entities we,
4863: wip_discrete_jobs wdj
4864: WHERE we.organization_id = wp.organization_id
4865: AND we.entity_type = 5

Line 4882: FROM wsm_parameters wp,

4878:
4879: CURSOR lot_based_jobs IS
4880: SELECT wdj.wip_entity_id,
4881: wdj.common_routing_sequence_id common_rtg_seq_id
4882: FROM wsm_parameters wp,
4883: wip_entities we,
4884: wip_discrete_jobs wdj
4885: WHERE wdj.organization_id = wp.organization_id
4886: AND we.organization_id = wp.organization_id

Line 5260: from wsm_parameters

5256: l_stmt_num := 10;
5257:
5258: select nvl(OP_SEQ_NUM_INCREMENT, 10)
5259: into l_op_seq_incr
5260: from wsm_parameters
5261: where ORGANIZATION_ID = p_org_id;
5262:
5263: l_stmt_num := 20;
5264: select start_quantity