APPS.WSM_JOBCOPIES_PVT dependencies on WSM_PARAMETERS

Line 3877: from wsm_parameters

3873:
3874: IF p_insert_wip = 1 THEN
3875: select nvl(OP_SEQ_NUM_INCREMENT, 10)
3876: into l_op_seq_incr
3877: from wsm_parameters
3878: where ORGANIZATION_ID = p_org_id;
3879: END IF;
3880:
3881: INSERT into WSM_LOT_BASED_JOBS

Line 5092: FROM wsm_parameters wp,

5088: wdj.bom_revision_date,
5089: wdj.wip_supply_type,
5090: 1 upg_success, -- Will indicate Upgrade Successful or failure in the PLSQL table t_upgrade_jobs
5091: '' err_buf -- Will contain the error message for failed jobs
5092: FROM wsm_parameters wp,
5093: wip_entities we,
5094: wip_discrete_jobs wdj
5095: WHERE we.organization_id = wp.organization_id
5096: AND we.entity_type = 5

Line 5113: FROM wsm_parameters wp,

5109:
5110: CURSOR lot_based_jobs IS
5111: SELECT wdj.wip_entity_id,
5112: wdj.common_routing_sequence_id common_rtg_seq_id
5113: FROM wsm_parameters wp,
5114: wip_entities we,
5115: wip_discrete_jobs wdj
5116: WHERE wdj.organization_id = wp.organization_id
5117: AND we.organization_id = wp.organization_id

Line 5491: from wsm_parameters

5487: l_stmt_num := 10;
5488:
5489: select nvl(OP_SEQ_NUM_INCREMENT, 10)
5490: into l_op_seq_incr
5491: from wsm_parameters
5492: where ORGANIZATION_ID = p_org_id;
5493:
5494: l_stmt_num := 20;
5495: select start_quantity