[Home] [Help]
267: l_buffer := NULL;
268: BEGIN
269: SELECT bd.department_code ||' '|| mel.location_codes ||' '|| eomd.accounting_class_code
270: INTO l_buffer
271: FROM eam_org_maint_defaults eomd, bom_departments bd, mtl_eam_locations mel,
272: mtl_parameters mp
273: WHERE mp.organization_id = l_org_id AND mp.maint_organization_id = eomd.organization_id
274: AND eomd.object_id = l_instance_id AND eomd.object_type = 50
275: AND eomd.owning_department_id = bd.department_id (+) AND eomd.area_id = mel.location_id(+);
389:
390: CURSOR Operation(p_wip_entity_id NUMBER) IS
391: SELECT
392: wo.operation_seq_num||' '||bd.department_code as value
393: FROM WIP_OPERATIONS wo,BOM_DEPARTMENTS bd
394: WHERE wo.wip_entity_id=p_wip_entity_id
395: AND wo.department_id=bd.department_id;
396:
397: CURSOR Resource_Details(p_wip_entity_id NUMBER) IS
418: ' '||bd.department_code||' '||PJM_PROJECT.ALL_PROJ_IDTONUM(wdj.project_id)||' '||
419: PJM_PROJECT.ALL_TASK_IDTONUM(wdj.task_id)) as value
420: FROM WIP_ENTITIES we,WIP_DISCRETE_JOBS wdj,CSI_ITEM_INSTANCES cii,
421: EAM_WORK_ORDER_DETAILS ewod,
422: BOM_DEPARTMENTS bd, MTL_SYSTEM_ITEMS_B_KFV msik, MTL_SYSTEM_ITEMS_B_KFV msik1,
423: MTL_PARAMETERS mp
424: WHERE we.wip_entity_id = p_wip_entity_id
425: AND we.wip_entity_id = wdj.wip_entity_id
426: AND wdj.wip_entity_id = ewod.wip_entity_id