[Home] [Help]
47: WE.ENTITY_TYPE
48: FROM WIP_OPERATION_RESOURCES WOR,
49: WIP_OPERATIONS WO,
50: WIP_DISCRETE_JOBS WDJ,
51: WIP_ENTITIES WE
52: WHERE WO.WIP_ENTITY_ID = P_Wip_Entity_Id
53: AND WO.ORGANIZATION_ID = P_Organization_Id
54: AND WE.WIP_ENTITY_ID = WDJ.WIP_ENTITY_ID
55: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
86: ORDER BY WO.OPERATION_SEQ_NUM;
87:
88: CURSOR Cuom IS
89: SELECT msi.PRIMARY_UOM_CODE
90: FROM wip_entities we,
91: mtl_system_items msi
92: WHERE we.wip_entity_id = P_Wip_Entity_Id
93: AND we.organization_id = P_Organization_Id
94: AND msi.inventory_item_id = we.primary_item_id
133: begin
134: l_osp_item_id := -1;
135: SELECT br.PURCHASE_ITEM_ID
136: into l_osp_item_id
137: from wip_entities we,
138: wip_operation_resources wor,
139: bom_resources br
140: where we.wip_entity_id = p_wip_entity_id
141: and we.organization_id = p_organization_id
254: BEGIN
255: l_osp_item_id := -1;
256: SELECT br.PURCHASE_ITEM_ID
257: into l_osp_item_id
258: from wip_entities we,
259: wip_operation_resources wor,
260: bom_resources br
261: where we.wip_entity_id = p_wip_entity_id
262: and we.organization_id = p_organization_id
614: FND_USER fu, BOM_DEPARTMENTS bd,
615: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
616: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
617: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
618: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
619: WHERE op1.organization_id = wor.organization_id
620: AND op1.wip_entity_id = wor.wip_entity_id
621: AND op1.operation_seq_num = wor.operation_seq_num
622: AND decode(nvl(P_Resource_Seq_Num, -1),
807: FND_USER fu, BOM_DEPARTMENTS bd,
808: MTL_SYSTEM_ITEMS msi, BOM_RESOURCES br,
809: MTL_PARAMETERS mp, WIP_OPERATION_RESOURCES wor,
810: WIP_OPERATIONS op2, WIP_OPERATIONS op1,
811: WIP_DISCRETE_JOBS wdj, WIP_ENTITIES we
812: WHERE op1.organization_id = wor.organization_id
813: AND op1.wip_entity_id = wor.wip_entity_id
814: AND op1.operation_seq_num = wor.operation_seq_num
815: AND decode(nvl(P_Resource_Seq_Num, -1),