DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on WSMPUTIL

Line 3821: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id

3817: SELECT recommended
3818: INTO l_is_curr_op_reco
3819: FROM wsm_copy_operations
3820: WHERE wip_entity_id = p_wip_entity_id
3821: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id
3822: (l_curr_op_seq_id,
3823: p_wip_entity_id);
3824:
3825: -- End : Changes to fix bug 3452913 --

Line 5086: WSMPUTIL.GET_JOB_BOM_SEQ_ID(wdj.wip_entity_id) bill_sequence_id,

5082: wdj.common_routing_sequence_id common_rtg_seq_id,
5083: nvl(wdj.routing_revision_date, sysdate) routing_revision_date,
5084: decode(wdj.job_type, 1, wdj.primary_item_id, wdj.bom_reference_id) bill_item_id,
5085: wdj.alternate_bom_designator alt_bom_desig,
5086: WSMPUTIL.GET_JOB_BOM_SEQ_ID(wdj.wip_entity_id) bill_sequence_id,
5087: wdj.common_bom_sequence_id common_bom_seq_id,
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