DBA Data[Home] [Help]

APPS.EAM_CREATEUPDATE_WO_PVT dependencies on BOM_RESOURCES

Line 169: FROM BOM_RESOURCES

165: CURSOR resources
166: (l_resource_id NUMBER,l_organization_id NUMBER)
167: IS
168: SELECT autocharge_type
169: FROM BOM_RESOURCES
170: WHERE resource_id = l_resource_id
171: AND organization_id = l_organization_id;
172:
173: l_resources resources%ROWTYPE;

Line 1799: FROM BOM_RESOURCES

1795: CURSOR resources
1796: (l_resource_id NUMBER,l_organization_id NUMBER)
1797: IS
1798: SELECT autocharge_type
1799: FROM BOM_RESOURCES
1800: WHERE resource_id = l_resource_id
1801: AND organization_id = l_organization_id;
1802:
1803: l_resources resources%ROWTYPE;

Line 3183: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br

3179: AND woru.operation_seq_num = wor.operation_seq_num
3180: AND woru.resource_seq_num = wor.resource_seq_num
3181: AND woru.instance_id IS NOT NULL
3182: AND woru.serial_number IS NULL) assigned_hours
3183: FROM WIP_OPERATION_RESOURCES wor,MTL_UOM_CONVERSIONS con,BOM_RESOURCES br
3184: WHERE wor.wip_entity_id = p_wip_entity_id
3185: AND wor.resource_id = br.resource_id
3186: AND br.resource_type = 2 --for person type resources only
3187: AND con.uom_code = wor. uom_code