[Home] [Help]
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
127: AND wlbj.wip_entity_id = wdj.wip_entity_id
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
143: AND wlbj.wip_entity_id = wdj.wip_entity_id
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
192: -- AND wlbj.wip_entity_id = wdj.wip_entity_id
1222: wdj.primary_item_id
1223: into l_st_lot_number,
1224: l_st_inv_item_id
1225: from wip_entities we,
1226: wip_discrete_jobs wdj
1227: where we.wip_entity_name = l_starting_jobs_tbl(l_rep_job_index).wip_entity_name
1228: and we.wip_entity_id = wdj.wip_entity_id
1229: and we.organization_id = l_txn_header_rec.organization_id;
1230:
1243: wdj.primary_item_id
1244: into l_st_lot_number,
1245: l_st_inv_item_id
1246: from wip_entities we,
1247: wip_discrete_jobs wdj
1248: where we.wip_entity_name = nvl(l_starting_jobs_tbl(l_rep_job_index).wip_entity_name,we.wip_entity_name)
1249: and we.wip_entity_id = wdj.wip_entity_id
1250: and we.wip_entity_id = l_starting_jobs_tbl(l_rep_job_index).wip_entity_id
1251: and we.organization_id = l_txn_header_rec.organization_id;