APPS.EAM_PROCESS_WO_UTIL_PVT dependencies on WIP_DISCRETE_JOBS

Line 151: --bug# 8363544, using wip_discrete_jobs.maintenance_object_id instead of wip_discrete_jobs.asset_number which is no more used after R12

147: end if;
148:
149: if((p_wip_entity_id is not null) and (p_organization_id is not null)) then
150:
151: --bug# 8363544, using wip_discrete_jobs.maintenance_object_id instead of wip_discrete_jobs.asset_number which is no more used after R12
152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item
153: -- there is no asset number for non-serialized item
154: -- Use wdj.rebuild_item_id as group id for non-serialized items; otherwise, find group id in table "csi_item_instances" as well.
155: SELECT wdj.project_id, wdj.task_id, we.wip_entity_name, wdj.maintenance_object_id,

Line 152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item

148:
149: if((p_wip_entity_id is not null) and (p_organization_id is not null)) then
150:
151: --bug# 8363544, using wip_discrete_jobs.maintenance_object_id instead of wip_discrete_jobs.asset_number which is no more used after R12
152: -- then find serial number, inventory_item_id in csi_item_instances table with wip_discrete_jobs.maintenance_object_id for serialized item
153: -- there is no asset number for non-serialized item
154: -- Use wdj.rebuild_item_id as group id for non-serialized items; otherwise, find group id in table "csi_item_instances" as well.
155: SELECT wdj.project_id, wdj.task_id, we.wip_entity_name, wdj.maintenance_object_id,
156: wdj.maintenance_object_type, wdj.organization_id, wdj.priority

Line 159: FROM wip_discrete_jobs wdj, wip_entities we

155: SELECT wdj.project_id, wdj.task_id, we.wip_entity_name, wdj.maintenance_object_id,
156: wdj.maintenance_object_type, wdj.organization_id, wdj.priority
157: INTO l_project_id,l_task_id, l_wip_entity_name, l_maintenance_object_id,
158: l_maintenance_object_type, l_organization_id, l_priority
159: FROM wip_discrete_jobs wdj, wip_entities we
160: WHERE wdj.wip_entity_id = p_wip_entity_id
161: AND wdj.organization_id = p_organization_id
162: AND wdj.wip_entity_id = we.wip_entity_id;
163:

Line 186: from cst_cat_ele_exp_assocs_v cceav, wip_accounting_classes wac,wip_discrete_jobs wdj

182: 4,wac.outside_proc_variance_account,
183: 5,wac.overhead_variance_account,wac.material_variance_account) variance_account_id
184:
185: into l_material_account,l_material_variance_account
186: from cst_cat_ele_exp_assocs_v cceav, wip_accounting_classes wac,wip_discrete_jobs wdj
187: where wdj.organization_id = p_organization_id and
188: wdj.wip_entity_id = p_wip_entity_id and
189: wac.class_code = wdj.class_code and
190: wac.organization_id= wdj.organization_id and

Line 197: from wip_discrete_jobs wdj

193: nvl(cceav.end_date,sysdate+1) >= sysdate;
194: else
195: select wdj.material_account, wdj.material_variance_account
196: into l_material_account,l_material_variance_account
197: from wip_discrete_jobs wdj
198: where wdj.wip_entity_id = p_wip_entity_id and
199: wdj.organization_id = p_organization_id;
200: end if;
201: