APPS.WSMPLOAD dependencies on WSM_LOT_BASED_JOBS

Line 122: FROM wsm_lot_based_jobs wlbj,

118: WSMPUTIL.GET_JOB_BOM_SEQ_ID(wdj.wip_entity_id) bill_sequence_id, -- Added : To fix bug #3286849
119: wdj.common_bom_sequence_id,
120: wdj.bom_revision_date,
121: wdj.wip_supply_type
122: FROM wsm_lot_based_jobs wlbj,
123: wip_discrete_jobs wdj,
124: wsm_sm_resulting_jobs wsrj
125: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
126: AND wsrj.wip_entity_id = wlbj.wip_entity_id

Line 138: FROM wsm_lot_based_jobs wlbj,

134: CURSOR C_INF_SCH_PAR_REP_JOBS IS
135: SELECT distinct(wdj.wip_entity_id) wip_entity_id,
136: wdj.organization_id,
137: decode(wlbj.on_rec_path, 'Y', WIP_CONSTANTS.MIDPOINT_FORWARDS, WIP_CONSTANTS.CURRENT_OP) inf_sch_mode
138: FROM wsm_lot_based_jobs wlbj,
139: wip_discrete_jobs wdj,
140: wsm_sm_resulting_jobs wsrj
141: WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
142: AND wsrj.wip_entity_id = wlbj.wip_entity_id

Line 187: -- FROM wsm_lot_based_jobs wlbj,

183: -- l_stmt_num := 47.1;
184: --
185: -- SELECT count(distinct(wdj.wip_entity_id))
186: -- INTO l_temp
187: -- FROM wsm_lot_based_jobs wlbj,
188: -- wip_discrete_jobs wdj,
189: -- wsm_sm_resulting_jobs wsrj
190: -- WHERE wsrj.internal_group_id = WSMPLOAD.G_GROUP_ID
191: -- AND wsrj.wip_entity_id = wlbj.wip_entity_id

Line 378: UPDATE wsm_lot_based_jobs

374: END IF;
375:
376: l_stmt_num := 47.4;
377:
378: UPDATE wsm_lot_based_jobs
379: SET internal_copy_type = 0,
380: copy_parent_wip_entity_id = NULL
381: WHERE wip_entity_id = c_algorithm_rec.wip_entity_id;
382: