DBA Data[Home] [Help]

APPS.WSM_JOBCOPIES_PVT dependencies on WSMPUTIL

Line 3590: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id

3586: SELECT recommended
3587: INTO l_is_curr_op_reco
3588: FROM wsm_copy_operations
3589: WHERE wip_entity_id = p_wip_entity_id
3590: AND operation_sequence_id = WSMPUTIL.replacement_copy_op_seq_id
3591: (l_curr_op_seq_id,
3592: p_wip_entity_id);
3593:
3594: -- End : Changes to fix bug 3452913 --

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

4851: wdj.common_routing_sequence_id common_rtg_seq_id,
4852: nvl(wdj.routing_revision_date, sysdate) routing_revision_date,
4853: decode(wdj.job_type, 1, wdj.primary_item_id, wdj.bom_reference_id) bill_item_id,
4854: wdj.alternate_bom_designator alt_bom_desig,
4855: WSMPUTIL.GET_JOB_BOM_SEQ_ID(wdj.wip_entity_id) bill_sequence_id,
4856: wdj.common_bom_sequence_id common_bom_seq_id,
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