[Home] [Help]
43: WE.ENTITY_TYPE
44: FROM WIP_OPERATION_RESOURCES WOR,
45: WIP_OPERATIONS WO,
46: WIP_DISCRETE_JOBS WDJ,
47: WIP_ENTITIES WE
48: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
49: AND WO.ORGANIZATION_ID = P_Organization_Id
50: AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
51: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
82: ORDER BY WO.OPERATION_SEQ_NUM;
83:
84: CURSOR Cuom IS
85: SELECT msi.PRIMARY_UOM_CODE
86: FROM wip_entities we,
87: mtl_system_items msi
88: WHERE we.wip_entity_id = P_Wip_Entity_Id
89: AND we.organization_id = P_Organization_Id
90: AND msi.inventory_item_id = we.primary_item_id
121: begin
122: l_osp_item_id := -1;
123: SELECT br.PURCHASE_ITEM_ID
124: into l_osp_item_id
125: from wip_entities we,
126: wip_operation_resources wor,
127: bom_resources br
128: where we.wip_entity_id = p_wip_entity_id
129: and we.organization_id = p_organization_id
241: BEGIN
242: l_osp_item_id := -1;
243: SELECT br.PURCHASE_ITEM_ID
244: into l_osp_item_id
245: from wip_entities we,
246: wip_operation_resources wor,
247: bom_resources br
248: where we.wip_entity_id = p_wip_entity_id
249: and we.organization_id = p_organization_id
566: FND_USER fu, BOM_DEPARTMENTS bd,
567: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
568: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
569: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
570: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
571: WHERE op1.organization_id = wor.organization_id
572: AND op1.wip_entity_id = wor.wip_entity_id
573: AND op1.operation_seq_num = wor.operation_seq_num
574: AND decode(nvl(P_Resource_Seq_Num, -1),
750: FND_USER fu, BOM_DEPARTMENTS bd,
751: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
752: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
753: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
754: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
755: WHERE op1.organization_id = wor.organization_id
756: AND op1.wip_entity_id = wor.wip_entity_id
757: AND op1.operation_seq_num = wor.operation_seq_num
758: AND decode(nvl(P_Resource_Seq_Num, -1),